[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.