>Hello all ADO/VB gurus,
>
>I'm having trouble getting the ADO.Recordset.Find method to work when the value for the criteria has an embedded single quote.
>
I don't know if it works in ADO, but in SQL Server, you have to use a double single-quote, e.g.,
Instead of "Dave's Art and Pawn"
It would have to be "Dave''s Art and Pawn"
You might try that and see if that works.
Insanity: Doing the same thing over and over and expecting different results.