Search a query using a form

chris89

Registered User.
Local time
Today, 06:24
Joined
Nov 28, 2011
Messages
71
How can I filter a query based on several drop down list box so that the user can enter the criteria for the query?
I actually want that if he chooses from one box the query returns for that specific criteria.
If he chooses also from the second box ,query lists matches from first AND second choises etc. and if he doesn t choose anything the query appears as it is?

Thank you in advance
 
The IPad cannot view the video so cannot comment on it but the basic approach in short hand is

Where (field1=box1 or box1 is null) And (Field2=box2 or box2 is null) etc

Brian
 
Thank you for your responses!
Is there a way to choose the query (also by dropdown list) the form will search?
 

Users who are viewing this thread

Back
Top Bottom