Filtering Problem with word (bos'n)

a_20120

tan
Local time
Today, 03:57
Joined
Nov 21, 2006
Messages
175
Words Shich Include ( ' ) Single Quote Can't be filtered

Hello everybody,
I have a project, one part of that is filtering according entry of DATA, it works well, but
Code:
Me.meaning_txt.Value = DLookup("[Farsi]", "tblDictionary", "[Words] = '" & Me.RelativeWord.Value & "'")
the filter works well, but there is a word bos'n, when I enter the word bos, I got an error as attachment
what is the solution
 

Attachments

  • untitled.JPG
    untitled.JPG
    12.8 KB · Views: 107
Last edited:
I mean the words which contains (') Single Quote, cant be filtered.
What is the solution?
 
I found the solution from other place, just instead of using ( ' ) use ( "" )
 

Users who are viewing this thread

Back
Top Bottom