Access Reports

[Bruce]

How do I stop a Report from running until a macro that I have told to run on
open is done running? I have this report that needs dates and data
information from another table. This table is updated as part of the on open
macro for the report. However when the report is opened, it runs with the old
data from the table (which of course is wrong). I need to somehow suspend the
opening of this report until the table has been updated. Any and all help
would be most appreciated.

 

[John]

How do I stop a Report from running until a macro that I have told to run on
open is done running? I have this report that needs dates and data
information from another table. This table is updated as part of the on open
macro for the report. However when the report is opened, it runs with the old
data from the table (which of course is wrong). I need to somehow suspend the
opening of this report until the table has been updated. Any and all help
would be most appreciated.

Are you starting the report with a command button?

Do you know how to edit the event code BEHIND a command button?

IE- to arrange the events in the order you want them to run

 

[Bruce]

John,

The report is being launched from main report menu, or from the design view.

Not sure on how to edit the code behind the command button.

 

[Allan V. Pimble]

I prefer to create a form that runs your "macro" when it opens. When it
closes, have it call your report.

 

[Bruce]

John & Allen,

Thank you for all of your help. I was able to determine what I was doing
wrong. On the macro that runs on the on open (of the report), I changed the
Open Form action Window Mode from normal to dialog, this kept the form on top
and stopped the report from fully opening. This change now permitted the
report settings to be entered into the form and give underlying macros a
chance to complete prior to opening the report.

Thanks again for all of your help.