Update Statement

Hi, can anyone help me debug the following erroneous sql code for updating a particular record?

sql = "Update Table1 Set Location = '" & Trim(Text1.Text) & "', " & _
"Remarks = '" & Trim(Text2.Text) & "' " & _
"Where " & _
"Title = '" & Title & "' And " & _
"Author = '" & Author & "'"

Thanx.

[RobZeilinga]

I can't see anything Wrong, What error is SQL returning? what type of fields are location & remarks?

If you are executing this query in MS Access, you need to add a semi colon to the end of the sql. Update ... Where Title = 'Title here';

Hi,

thanks for your responses. My sql statement is run from vb, and the entire error msg goes like this "Run time error '-2147217900(80040E14)': [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in Update statement". Location field is numeric (Long Integer) whereas Remarks field is a memo field.

Thanx.

[Lothar Haensler]

since 'Location' is numeric, you shouldn't put single quotes around it.