On Open Event - Run query

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.
 
G

Golfinray

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
 
Top