RTE '3077' if a Surname has a Single quote

B

Bonnie V

RTE '3077'
Syntax error (missing operater) in expression:

the code works fine if there is no single quote in a name:

rs.FindFirst "[Surname Given Middle] = '" & Me!
[Combo0] & "'"
 
V

Van T. Dinh

Use double-quotes:

rs.FindFirst "[Surname Given Middle] = """ & Me![Combo0] & """"
 
Top