Run Queries automatically from Report

[NEEDHELP123]

Does anyone know how to make a report run queries automatically? For example I want to run Report1 but it depends on three sets of queries. When I open Report1 I want it to be updated with the latest data.


Access 2003

 

[KeithG]

Is the report opened from a button on a form?

 

[NEEDHELP123]

Users will be running reports via the Switchboard. After they have entered their data they will return to the Switchboard and select a report they want to see. When they select a report that where I want the report to automatically update so they see the latest data.

 

[KeithG]

You could add code to your button to run the queries. You could use docmd.runSql(sql statement)