Search based on form

[ccordner]

I have a form with a field "txtSearchText" which my query then uses to filter records before displaying a form.



Is it possible to build a query criteria that searches for any of the words in the field? So "John Smith" would find anything with "John" or "Smith" in?

Thanks
Chris

[azhar2006]

See this


http://allenbrowne.com/AppFindAsUType.html

[orange]

You might also find this link useful.