Search a query using a form

[chris89]

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

 

[jdraw]

Take a look at this free video for ideas
http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[Brianwarnock]

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

 

[chris89]

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