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.