Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening Report with Lookup Menu

Status
Not open for further replies.

MySki

Technical User
Feb 20, 2003
77
US
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
 
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]
 
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
 
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top