Open Form

  • Thread starter Thread starter Adrienne
  • Start date Start date
A

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?
 
Adrienne said:
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?
Click to expand...

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
 
Back
Top