Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runnig a macro after on "timer"

Status
Not open for further replies.

fludan

Technical User
Feb 1, 2002
41
US
Hi

I would like to run a macro after the form is open for 20sec.

I don't no how to do with with a event procedure

Pleas Help

Thanks
Frank
 
Code:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
Me.TimerInterval = 20000

End Sub

Sub Form_Timer()

Call MACRONAME

End Sub
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top