On May 30, 3:43*am, "Jeanette Cunningham"
wrote:
Create another form that shows the message about taking a long time and open
it just before you open the form that is slow to load.
When the slow form has loaded, then you can close the form with the message.


I tried that but couldn't get it to work. The form with the loading
message doesn't display. I tried changing the modal and popup settings
and it still didn't work. Here's my code in form1:

Private Sub Command0_Click()
DoCmd.OpenForm "FormWithLoadMessage"
DoCmd.OpenForm "Form2"
End Sub








If you want to show a progress bar, there is a sample one in Albert Kallal's
Word Merge sample database.

Open this pagehttp://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

and scroll down to Super Easy Word Merge. Download the 2000 merge code.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"cr113" wrote in message

...
On May 29, 4:32 pm, cr113 wrote:

I've got a form1 that calls form2. The load event of form2 takes
several minutes to run, it has to do a lot of data processing. I'd
like to display some sort of message that either shows how the load is
progressing or at the very least that this is going to take awhile.
The problem is I can't seem to get control of the screen while the
load is taking place, it's basically locked up.

I forgot to mention I'm using Access 2007.