splash form problem

[DDBeards]

I have a FrmSplash form open and then I run code to load the data and check
out the user. All works fine accept the forms boarder and title appear and
the body of the form does not until the other code is finished.

I have tried loading on timer and tried running fromt he autoexec macro
nothing seems to work. Is there a way to delay the code until the form is
completly loaded or to set the timer to fire only once?

thanks

Chris

 

[DDBeards]

Right now I have a hidden form frmLoadData start from the startup option.
This is the code in that frmLoadData. It opens the frmsplash but only shows
the title and boarder, then runs the macro maclocaldata. when that macro
ends, and not until then does the body of the frmsplash appear. I need for
the entire form to be displayed then the macro run.

Private Sub Form_Open(Cancel As Integer)
DoCmd.OpenForm "frmsplash", acNormal, , , acFormEdit, acWindowNormal
End Sub

Private Sub StartUP()
DoCmd.RunMacro "MacLocalData" ' Load Data
End Sub