Drop-down list box for reporting parameters

  • Thread starter Thread starter ET Sherman
  • Start date Start date
E

ET Sherman

Hello Ann,

This will be an easy approach to your question:

1. Create a Query, say "MyReportQry", to base your report
on that includes all the necessary fields from your
table. This will be the Record Source for the report.

2. Create a Form, say "MyReportForm", that will be used to
print reports. On this form, add a Combo Box Control or
List Box Control "MyComboBox" that has all of your
departments.

3. In the design grid for MyReportQry, set the Department
field's Criteria to:

=Forms!MyReportForm!MyComboBox

4. On your form you can add a Command Button to print the
report. Set the On Click event of this button to:

DoCmd.OpenReport "MyReportName", acViewPreview

Hope this helped.

ET Sherman
 
Here is a good set of access tools including Choose Report from List
which does this.
 
Back
Top