Originally Posted by
hendrikbez
Sorry for replying only now, did have a death in my family.
Hendrik, I am sorry for your loss.
You don't have to apologise for anything.
About your issue, create a query with all available fields of your table plus a field (say AllWords) with all fields (words) joined in one, separated with a blank space. For example:
Code:
AllWords: & " " & [word1] & " " & [word2] & " " & [word3]...& " " [word13] & " "
After that, in a bound form on that query, you can set the filter as follows: [AllWords] LIKE "* " & Me.txtSearch & " *"
I attached a sample based on that aproach.
I hope it helps.
Cheers,
John