Howdy, Stranger!

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

Categories

Syntax Error

McDukMcDuk Member Posts: 1
[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.