RTE '3077' if a Surname has a Single quote

  • Thread starter Thread starter Bonnie V
  • Start date Start date
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] & "'"
 
Back
Top