Update statement syntax error

[shalskedar]

In my Db i need to update 3 columns..Below is my code to update but giving me an error...Can anyone Plz help me with this...

str = "update [outer2] set [outer2].[Refno]='" & UserForm1.TextBox2.Text & "'"&","&[outer2].[Address]='"&UserForm1.TextBox1.Text & "'" ,[outer2].[Type]= '" & UserForm1.ComboBox1.Text & "'"

[orangeCat]

What error are you receiving?

[nico5038]

The quotes aren't balanced correctly, try:

str = "update [outer2] set [outer2].[Refno]='" & UserForm1.TextBox2.Text & "', [outer2].[Address]='" & UserForm1.TextBox1.Text & "',[outer2].[Type]= '" & UserForm1.ComboBox1.Text & "'"

Nic;o)

[shalskedar]

Thanks !!!Its working