Syntax error in query expression

[Guest]

I allow a user to insert a Client Name in one form (Entry), and when matched
in a drop-down list (Last Name), pressing a command button retrieves and
displays a pop-up form with details of that client.
The match code in the Event Procedure contains the following:

Dim stLinkCriteria As String
stLinkCriteria = "[Last Name]=" & "'" & Me![Combo64] & "'"

This works fine except when the Client name has an apostrophe (O'Doherty)
The system halts with a message:
Syntax Error (missing operator) in query expression '[Last Name]='O'Doherty.

How do I overcome this?

 

[Guest]

Try

Dim stLinkCriteria As String
stLinkCriteria = "[Last Name]=" & "'" & Replace(Me![Combo64],"'","''") & "'"

 

[fredg]

stLinkCriteria = "[Last Name]=" & "'" & Me![Combo64] & "'"

stLinkCriteria = "[Last Name]=""" & Me![Combo64] & """"

Just for clarity, that's
= " " " & Me![Combo64] & " " " "

 

[Guest]

One of almost imeediate 2 replies... both worked.
Thanks
--
GAF

stLinkCriteria = "[Last Name]=" & "'" & Me![Combo64] & "'"

stLinkCriteria = "[Last Name]=""" & Me![Combo64] & """"

Just for clarity, that's
= " " " & Me![Combo64] & " " " "

 

[Guest]

One of almost imeediate 2 replies... both worked.
Thanks
--
GAF

Try

Dim stLinkCriteria As String
stLinkCriteria = "[Last Name]=" & "'" & Replace(Me![Combo64],"'","''") & "'"

--
Good Luck
BS"D

I allow a user to insert a Client Name in one form (Entry), and when matched
in a drop-down list (Last Name), pressing a command button retrieves and
displays a pop-up form with details of that client.
The match code in the Event Procedure contains the following:

Dim stLinkCriteria As String
stLinkCriteria = "[Last Name]=" & "'" & Me![Combo64] & "'"

This works fine except when the Client name has an apostrophe (O'Doherty)
The system halts with a message:
Syntax Error (missing operator) in query expression '[Last Name]='O'Doherty.

How do I overcome this?