Entering multiple interactive parameters

[Mich]

Hi,
I am trying to create a query with the following criteria:
1) Prompt user to enter data from a list/combo box - Required data
2) And have the option to enter between dates if date values are not entered
all records should appear
3) And inlude 3 other between currency values.

Can the request to enter the paramaters be displayed all at once?

Much appreciated.

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The article explains how to set up a form where the user can enter the
criteria, and you apply it to filter a form or report.

It includes a sample to download and pull apart to see how it works. The
sample includes combos and a date range, and it explains how you can add as
many critieria as you wish.