On Open Event - Run query

  • Thread starter Thread starter AWentz
  • Start date Start date
A

AWentz

I created a report from a simple query. From the report how do I create a On
Open Event = Run query, so that I don't have to click on the query and run
each time to refresh my report.
Beginner in Access and cannot find the steps to accomplish this.

Thank you.
 
In the combo or list box on the report, right click and go to the events tab.
On the afterupdate event, start the code builder (the little button out to
the right.) Type:
Me.Requery
 
That is not necessary. The query is executed each time the report is run.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query completions in code - threading issue? 1
Can't create a report from my query in Access 1
Records reported 69 times 3
Using a query as base for report 1
Report Won't Run - Query Is Too Complex 7
Access #Error & Excel Pivot 0
Rerun query 2
Save Report output to be redisplayed by Command Button? 3

Back
Top