Multiple comboboxes to generate reports!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am making a database and want to have combo boxes that control report
generation. To exemplify:

Combo box with REGION
Combo box with GROUP
Combo box with DATE

I have made a form where these drops down, fed out of a table/query.
What I would like to do is to make it possible to generate reports
displaying only what’s chosen in these combo boxes, and if nothing is chosen
in one or either of the boxes, it should include all fields from these boxes!

Could someone help me??
 
I have managed to get it halfway done, but only if all the dropdown boxes has
been used, i want to be able to not change e.g. region, and therefore get a
report with all the regions; and information narrowed down by the other
fields that has been chosen
 
Jorgen, take a look at:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The article explains how to create a filter string from just those boxes
where the user enters something, and then apply it to a form or report.
Includes a sample database to download and see how it works.
 
Back
Top