On Open Event - Run query

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

 

[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

 

[Klatuu]

That is not necessary. The query is executed each time the report is run.