How to make a form close after a set period of time.

Private Sub Form_Current()
Dim dWait As Variant
DoCmd.OpenForm "frmSplashScreen"
dWait = DateAdd("s", 10, Time())
While Time() < dWait
DoEvents
Wend
DoCmd.Close acForm, "frmSplashScreen"
DoCmd.OpenForm "frmMenu"
End Sub

why do you want it run in the Form's current event?
 

Users who are viewing this thread

Back
Top Bottom