How to break syntax into multiple lines

[sohailcdc]

Hi there
Thanks for your help in advance

I search over the form and learn how to create the simple Update query in VBA, BUT
I am unable to break the UPDATE statement into multiple lines and now I am getting "Syntax Error in UPDATE statement"

Following is the multiple line Update Statement

Dim strsql As String
strsql = "Update tblcurr" & _
"SET tblCurr.Currencyname =" & _
"[forms]![updatecurrency]![txtcurname]" & _
"WHERE (((tblCurr.Currencycode)=" & _
"[forms]![updatecurrency]![txtcurcode]));"
DoCmd.RunSQL strsql

Following is the one liner Update statement which, works perfectly

strsql = "UPDATE tblCurr SET tblCurr.Currencyname = [forms]![updatecurrency]![txtcurname] WHERE (((tblCurr.Currencycode)=[forms]![updatecurrency]![txtcurcode]));"

Have a good one

 

[Frothingslosh]

Check your spaces.

Easiest way in testing is to have the procedure print the string to the immediate window rather than running it. That way you can look at the final product.

 

[pbaldy]

Here's what Frothingslosh is referring to:

http://www.baldyweb.com/ImmediateWindow.htm

 

[sohailcdc]

Finally I learn something new today, which make my day
Thanks to all
Be happy alway

 

[Galaxiom]

This is a better way to format:

strsql = "Update tblcurr" _
       & " SET tblCurr.Currencyname =" _
       & " [forms]![updatecurrency]![txtcurname]" _
       & " WHERE (((tblCurr.Currencycode)=" _
       & " [forms]![updatecurrency]![txtcurcode]));"

See how it clearly shows the spaces all in a single column.