Report selection (1 Viewer)

[Elvi]

How do I create a report that allows me to select criteria.

I.E. one of the fields from the db is 'Topic': Environmental protection, Ecological integrity, etc.. I would like a report that returns all entries of a chosen topic, i.e. all environmental protection entries.

 

[Neal]

You could use a combo box on a form. The combo box would have the various topics (either listed or drawn from a table or query). On the After Update event, you write code saying:

DoCmd.OpenReport "YourReport",,,"[Topic] = Me!ComboTopic"

The report will open showing only items where the topic is equal to the selection in your ComboTopic control.