When the name contains an apostrophe

[exaccess]

Here is a question for the experienced people:
I have a query written in Visual Basic as follows
UA1 = Forms(ParName).Form.NOM
UA2 = Forms(ParName).Form.PRENOM
UA3 = Forms(ParName).Form.CARTE
Forms(ForName).Recordset.FindFirst "[NOM] = '" & UA1 & "'" & " And " & _
"[PRENOM] = '" & UA2 & "'" & " And " & _
"[CARTE] = '" & UAE & "'"
This query works and I can spot the record based on 3 fields and display it. Now I have discovered that we have a person who has an apostrophe in his name like O'Brian. The above code gives a syntax error in this case. What is the easiest way to handle this? Your help will save me a lot of work. Thanks.

 

[pbaldy]

About half way down:

http://www.baldyweb.com/BuildSQL.htm

 

[exaccess]

Works like a charm. Many thanks.

 

[pbaldy]

Happy to help!