Form doesn't completely appear

  • Thread starter Thread starter Tom Stoddard
  • Start date Start date
T

Tom Stoddard

I have created a button which runs code to synchronize two backend
databases. I wanted a message to be displayed while the synchronization is
being done so I created a simple form to use almost like a splash screen.
The border of the form appears but the code finishes running before the body
of the form is displayed so the form is closed without ever displaying the
intended message.

How can I get the form to completely display before the code finishes
running?
 
Hi Todd,

Use a doevents statement to allow the CPU to handle the lower priority task
of repainting the screen. Put it after the docmd.openform for your status
form. If you write additional messages to this form you will need additional
doevents statements.
 
Back
Top