Drop-down list box for reporting parameters

[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

 

[Carol Chisholm]

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

 

[Carol Chisholm]

http://www.rogersaccesslibrary.com/TableOfContents2k.asp