error while inserting a word containing apostrophe ( ' )

[darwish]

hello

i have a text box.
i insert a word in the text box and press the add button, here the word is being checked if it is already inserted into the database by the DLookUp method, and if it is not found, then it will be inserted normally by SQL insert statement.
I have 1 error appear when i enter a word having an apostrophe ex: Car's
The error is the following: Syntax error (missing operator) in query expression '[Customer_Name]='car's"

any word that don't have an apostrophe is working fine.

any help is appreciated.

Thank you

[Bob Fitz]

You may find the following link of some help: http://allenbrowne.com/casu-17.html

[trevor40]

use a browser to search for dlookup, select the top answer from microsoft, there should be examples of dlookup options.

Yous is missing quotes single and double to allow for your problem of the extra apostrophe.
the dlookup is formatted differently for numbers, text and dates.

sample for text...
DLookup("[image location]", "[images]", "[Con Note Number] = '" & Me.Consignment_Note_Number & "'")

note the extra single and double quotes there, ensure that your spaces are also set correctly.