I have a "housekeeping Form" set up that...
when triggerd by the main form, updates records, sends email, clears and refills an access table all of which runs from a Form.Load Event my problem is the form "PLEASE WAIT WHILE SYSTEM IS UPDATING" will not fully load while all these things are happning I have tried ME.Show and ME. Activate

I want the form to load completely and be visable during the whole process thill the ME.Close