Filtering data to produce report results.

[Gerimc]

I want to create a report depending upon a selection from a combo box. Should I create a form with a combo box on it to filter the results I need for my report or should i have a combo box on my report or is that possible?
I am filtering data for a particular year. I would ideally like a box to pop up that the user would select the year they want and a report would be produced.

 

[jdegeorge]

Gerimc

On the form where you have your PRINT button, add the combobox and call it lstFilter. Then, in the query that controls your report, add a field that the combo box is based on with the criteria of [forms]![your form name]![lstFilter], and you should be set. Hope this helps.

Jim DeGeorge