Runtime error '3077' in Combo Box on Form

[Dan Flynn]

I have an Access form which shows detail information for
500 member companies stored in one table. I added a
Combo Box on the form to quickly select a member
by "Company Name". For the most part, the Combo Box
works fine. However, for a few records, I'm getting
a "Runtime error '3077' Syntax error (missing operator)
in expression" message. When I click on the "debug"
button, the line that is highlighted in yellow in Visual
Basic reads . . .

rs.FindFirst "[Company Name] = '" & Me![Combo58] & "'"

Any ideas! Many thanks!

 

[May]

doesn the company name contain any special characters
like ' or "