Running query based on Form Text Box criteria with special features

[bluwind]

Hi all,
In the spirit of santa I will just preclude this thread with "I have searched this forum, I have searched it twice and only found stuff that was naughty not nice"

Ok with that out of the way.

I am trying to run a query and display the results in a report (the report side of it is childs play and not a problem). The problem I am having is that I have a search form which should allow the user to search any one of 6 fields (text boxes) or a combination of each. If the user enters something into a field then that search criteria must match. I wanted to have it so if all fields are left blank then it will show all entries in the database (but it isn't, it shows a blank report). I also wanted it to allow partial completion of boxes,
So for instance if I have 5 customers (Jones, Jonson, Jonus, jimjonkins, Janis) and I type "Jon" into the name field then I would like it to show the first 4 records as they all contain "jon" somewhere in their name but its not, its only allowing exact matchs.
I currently have '[forms]![Search_Customer]![Search_Name]'.


Any help would be greatly appreciated.

Rob

 

[namliam]

You have been naughty and as your punishment you will not be helped but instead told to go read more....

Go see this thread, see what you can learn and addapt to your needs:
http://www.access-programmers.co.uk/forums/showthread.php?p=1300908#post1300908

 

[bluwind]

Thanks for the quick reply Namliam, I must have missed that one in my search results.. I will have a read through and come back and shower you with praise when I get it working