Select from Drop down list

[Roger Bell]

I have designed a report based on a Query. At the moment the user has to type
in the criteria required into a Parameter Section. What I would like is that
the user is presented with a drop down list of the areas to save having to
type in the respective area.

Thanks for any help

 

[Allen Browne]

Create a little unbound form, with a combo where the user can make the
selection, and a command button to OpenReport.

Here's an example of firing off a report from such as form:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

Here's a more comprehensive example, where there are lots of boxes the user
can enter critieria into:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The example database in that last one applies the filter to the form, but
it's exactly the same to build the filter for the report.