Opening Report with Lookup Menu

[MySki]

HI,

I'm creating a report in Access that generates results by program office based on the the program office entered by the user. To eliminate multiple ways of inputing the office, and thus skewing report results, I want to have the user select the office from a drop-down list to generate the report. Is this possible?

Thanks

 

[dhookom]

Use a combo box on a form to create your criteria in the report's record source.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[MySki]

thanks for the quick response. I tried creating a combo box on a form and then setting the "onopen" event of the report to open the form. However, I just got the form in the background and the report parameters ran as set in the query, asking to enter the office (but not allowing you to select from the combo box).

Should I still be creating my parameter in the query the report is pulling from? How do I call up the form correctly to open the report?

Thanks again,

Lori

 

[dhookom]

I don't ever use a report to open a form. My forms with criteria are open and have the criteria entered. Then a command button or whatever open the report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]