Open Form

[Adrienne]

I would like to open a form called frmsplash for 3 seconds
and close the form and run a macro called OpenTblCANPV.
How can I accomplish this?

 

[Dirk Goldgar]

I would like to open a form called frmsplash for 3 seconds
and close the form and run a macro called OpenTblCANPV.
How can I accomplish this?

Use the Timer event of frmSplash to close it and run the macro. Set its
TimerInterval property to 3000 (3 seconds), and have an event procedure
for the Timer event like this:

Private Sub Form_Timer()

Me.TimerInterval = 0 ' disable timer
DoCmd.Close acForm, Me.Name, acSaveNo
DoCmd.RunMacro "OpenTblCANPV"

End Sub