SQL Statement in VB

[mans]

Hello,

I am using VB6 with Access2000. I am attempting to use the code below in VB to find the first person with a last name O’Malley (Assume Combo14 contains the name O'Malley). Because of the single quote in the LastName the statement fails and shuts down the program. Can someone please let me know how I can change the code below to enable it to locate names with single quotes inside them like O’Malley.

rt.FindFirst "total!LastName = '" & Combo14 & "'"

Thank You

 

[sunaj]

The simple way :
rt.FindFirst "total!LastName = '" & replace(Combo14,"'","''&quot & "'"

but watch out: if there's more than one single quote your program will fail. See thread222-8367
and

http://support.microsoft.com/support/kb/articles/Q202/9/55.ASP

Sunaj