Generating reports from combo selection help

[t3nchi]

I have a form with which I select a year from a dropdown combo box.

I want to open up a report after I select the year. How do I do that?

 

[carash77ash]

you need to create a select querry with the information you want. In the field year make the critera subject to the form combo box. eg

[Forms]![formname]![fieldname]

This creates a parameter for the query that must have a value for the query to return results.

Hope this helps

Ash