Run queries on open

[allong]

I have a table query which I have to update everytime new information is put into the database. The report that comes from this query has two other queries that is needed to actually get my information. I want to click on the report and automatically update call queries before the report opens. Is this possible?

 

[jdegeorge]

Yes, just put this code behind your print button BEFORE the code that prints the report:

docmd.openquery "qryname"

Hope this helps.

Jim DeGeorge