In Access 97, I have a user who has a few names, such as O'Brien and O'Ryan. When she types in the name field to do a search, as soon as she types in "o" and presses ENTER, she gets the following:
"Run-time error '3077', syntax error (missing operator) in expression".
Here's the line of code it's stopping on:
Me.RecordsetClone.FindFirst "[strWholeName]= '" & Me![Combo40] & "'"