I am sooo close to getting this now.
I have redone the form from scratch and it works for two criteria but not the rest...
The form I am now using is the "New Client Search" form in the database attached.
If you only use the search by status or search by name boxes then it works perfectly. I think you can even use both of them in conjunction. However if you try to search by Email, then it returns all results, or in the case of by nationality no results.
If you search "Jo" in client name then you get 2 results. Correct.
If you search by status and put in "cold" then results are also filtered.
However, if you search by email "hotmail" for example then it returns all results even though I have used the same criteria for both in the query
Like [Forms]![New Client Search].[QClientName] & "*"
Like [Forms]![New Client Search].[QEmail] & "*"
Any ideas? Also is it possible to change any of the search input boxes to combo boxes or would this be too complicated?