StartUp Macro

[DDBeards]

I have a large application (Access 2000) and I am trying to display a form
with a welcome message when the application starts up while a macro runs in
the background loading all the local tables. Well here is the problem, when
the macro runs the form displays first as designed however the data does not
appear. When the macro ends then the data appears. The data being displayed
is stored locally and the table is not affected by any of the macro commands.
Any ideas on how force the data into the form before the rest of the macro
runs?

Thanks

Chris

 

[John W. Vinson]

I have a large application (Access 2000) and I am trying to display a form
with a welcome message when the application starts up while a macro runs in
the background loading all the local tables. Well here is the problem, when
the macro runs the form displays first as designed however the data does not
appear. When the macro ends then the data appears. The data being displayed
is stored locally and the table is not affected by any of the macro commands.
Any ideas on how force the data into the form before the rest of the macro
runs?

Thanks

Chris

I'd suggest using the Tools... Startup menu to specify that the Form is the
startup form (rather than using a startup macro), and call the macro from that
form's Load event. The Load event will be processed before (as) the form
opens.