VB Prompts error msg when I use FindFirst or FindLast
to search a string which has puncutation characters viz., ' (single quote) or comma (,).... For Eg. "Tom's Inn"

myrs.Findfirst "Name = '" & tmpName & "'"

where tmpName is "Tom's Inn".


tmpName is a string Variable
Name is the fieldName in my Recordset MyRs

Pls try this & let me know.

Don't suggest me to remove those puncutation characters...
It is not possible to remove from my customers data.

Pls help me

Mohan Kumar VS.