Hello everybody,
I have a project, one part of that is filtering according entry of DATA, it works well, but
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

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 ( "" )