Syntax Error

[b][red]This message was edited by McDuk at 2006-3-14 17:9:25[/red][/b][hr]
I keep getting the error message

Run-time error '3077':
Syntax error (missing operator) in expression.

everytime i click on a command button.

I have a form that's supposed to save details to a recordset. It was working fine until only recently it started giving me this problem.

When i debug, it highlights the following piece of code:

Recordset.FindFirst "VendorName='" & txtVendorNAme & "'"

I found that if the text box control on the form includes a single quote (') in the name, it keeps giving this error.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!