Is it possible to create a dropdown filter for reports generated in Access?

[Marc Brown]

I am creating a report which refences two table. One lists activity types and descriptions, the other lists the historical productivities in those activities. The problem is there are hundreds of activities and I would like users the option easily filter the activities. The effect that I am looking for would very simmilar to the filters on Pivot Tables.

[patjones]

Are you opening the report from a form on which you can put the combo box in order to facilitate the filtering?

Pat

[Marc Brown]

On my navigation pane I have the form available to enter the records and a list of standard reports generated from the records, but there is no direct link between the form and the report.

[patjones]

I'm thinking along the lines of using the OpenReport method to open the filtered report:

DoCmd.OpenReport "Report Name", acViewPreview, , "[field name] = [combo value]"

The fourth argument in OpenReport is a filter argument, and it behaves just like the WHERE clause in a SQL query. Your report will open with the records filtered according to that argument. You can include AND's to enable filtering on more than one combo box selection. The simplest thing is probably to put a command button on the form which, when clicked, opens the report, with the OpenReport code being in the On Open event for the report.

Pat