Findfirst coping with apostrophy

L

Louverril

This works fine:

rs.FindFirst "[Item_Desc] = '" & Me![ItemList] & "'"

unless the Item Description contains an apostrophy

So hilary's book is trying to match hilary's book on the item list.

I have tried variations on:

strQuote = Chr$(34)
rs.FindFirst " & strQuote & [Item_Desc] & strQuote = '" & strQuote &
Me![ItemList] & strQuote & "'"

Trying to follow a previous posting on a forum but I can't make sence of it.

How can I cope with this. I do not want to replace the apostrophies on input.

Thanks Lou
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to avoid repeats customer names 3
Help with Evaluate/Eval 3
Finding identical addresses 3
still having problems with "and" in findfirst criteria statement. 4
FindFirst not recognizing dates 3
Finding a record in a subForm 0
Going to a record in a subform 0
Matching up two columns with different data 1

Top