drop down menus on reports

[Deb_Hendrix]

I am helping someone with a new database. He is not Access savvy and he wants
to be able to select report criteria from drop down menus as he runs the
report. For instance he might want to see sales rep 1, sales 3, and sales rep
4 on one report and he wants to select them with drop downs. Is there a way
to do this? When I have specific criteria, I enter them in the criteria box
on the associated query using the OR and AND if needed. Is it possible to do
this the way he wants them done? I just need an overview, not the specific
details. I'm assuming that it must be programmed and I am not a programmer so
I don't know if I can help him. Thanks.

 

[Jeff Boyce]

Since Access reports are intended for printing, a 'dropdown' on a printed
form doesn't really make much sense.

Instead, a common approach to setting criteria for a report to use is to
create a new form that will hold/gather the criteria, then use a query to
get the report's data, pointing to the (new) form for selection criteria.

Regards

Jeff Boyce
Microsoft Office/Access MVP