How to access report criteria using a drop down list

[Guest]

Please can you help me?
I have created a query and a report to view the query. Now I would like to
use a combo / drop down box to be able to access specific criteria within the
report.
Do I need to do this by creating a form and if so how?

 

[Guest]

Thats possible,

create a form and a dropdownbox
the a button with somekind of code like this:
docmd.openreport "[your report name]",acpreview,,"[your criteria]"

your criteria is like the where statement in a sql select query but withut
'where'

 

[Guest]

To add a combo or a list box to select a criteria you need to create a form.
After the form is created check this link on how to print a selected record

http://www.databasedev.co.uk/print_form_record.html