I have a form that has a bunch of option boxes.  The user selects the options
desired, and hits the "Go" button (which starts a bunch of VBA code that
drives the process).  After that, a series of queries are run - sometimes
numbering in the hundreds.  A progress bar control and status text box tell
the user how far into the process he/she is.

The problem is that if the user hits "Go", and then opens a different window
on top of the active form (say, to check email), then goes back to the form,
the Access window and form no longer update their contents.  As long as the
user leaves that window on top, the display works fine.  As soon as another
window covers it up, that window no longer updates itself until the entire
process is finished - which can take up to half an hour.

Is there something in VBA that I can call to force the screen to update
periodically?  I tried Me.Repaint (with Me being the active form), and it
didn't work.

Thanks,

Eric