Report selection on a field

[Mike Claiborne]

Instead of creating 10 or so reports, I would like to
select on a field and the report select only those records
from that field. In otherwords I have a plant and only
want to see a report on one area. I would like a drop down
list to select from. How can I do this?

 

[Jeff Boyce]

Mike

Typical approach to this is to create a form with a combo box (drop-down),
plus a command button that opens the selected report. One way to "fill" the
combo box is to create a small table that holds the (Access) name of the
report, plus a user-friendly name.

Let the users pick the friendly version, but use the Access report name to
open it.

Good luck

Jeff Boyce
<Access MVP>