I am trying to generate a report based off of a query. However, I am using a dropdown selction box to choose criteria for the query. Once the criteria is selected, the query automatically runs and the data view is displayed. I do not want the user to see this data view. I want a report to automatically generate and the data view of the results to go away. Can anyone help?
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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I make an Access query automatically open a report? 1
- Thread starter pretzal
- Start date
-
1
- #2
You need to create the report first. Have the wizard use the query as recordsource of the report, and make your buttons click event or the after update of the combo open the report (not the query).
Welcome to Tek-Tips - here's a faq describing how to get the most out of the membership faq181-2886.
One of the things mentioned, is to choose the right forum, since this is an Access question, it might be better addressed in one of the pure Access fora, for instance the reports forum (forum703). Some of the other Access fora are found in the Related Forums box at right;-)
Good Luck!
Roy-Vidar
Welcome to Tek-Tips - here's a faq describing how to get the most out of the membership faq181-2886.
One of the things mentioned, is to choose the right forum, since this is an Access question, it might be better addressed in one of the pure Access fora, for instance the reports forum (forum703). Some of the other Access fora are found in the Related Forums box at right;-)
Good Luck!
Roy-Vidar
- Status