Creating filtered reports using list boxes in forms or switchboard

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

Guest

I'm using Access 2003...

How do I create a filtered report via a form or switchboard using list boxes.

I have produced my reports using queries and can filter the data by typing
in the the relevant 'Criteria' in the query or set my queries as parameter
queries but I want the end users to select the filter criteria via pull down
lists.
I also want to nest the lists, as there will be 2 or more data fields used
to filter the search results.
 
In the criteria for the query reference to the form containing your
parameters, even if they are combo boxes, like this:

[Forms]![MyParameterForm]![MyValue]

Do this for each field and value in your form where you want to filter,
 
Back
Top