Run Queries automatically from Report

NEEDHELP123

Registered User.
Local time
Yesterday, 19:44
Joined
Jun 5, 2006
Messages
23
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
 
Is the report opened from a button on a form?
 
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.
 
You could add code to your button to run the queries. You could use docmd.runSql(sql statement)
 

Users who are viewing this thread

Back
Top Bottom