Want to Open Form for 5 Seconds Then Close

[smedvid]

I have a little form that I want to open to alert users to a status, then have the form automatically close after 5 seconds. I thought I could create a form with a text box (with my message), then execute a do loop for 5 seconds then close the form. I am not sure where to put the code... tried most of the form events... with no luck. tia, Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[jebry]

Hi Steve!

I got this from Mr. Brett Collins in another forum:

Option Compare Database
Option Explicit

Private Sub Form_Load()
Me.TimerInterval = 5000

End Sub

Sub Form_Timer()
DoCmd.Close
End Sub

Simple and to the point!
hth
Jeff Bridgham
bridgham@purdue.edu

 

[shelron]

you can also use the forms on timer event,

set the timer for 5 secs, then docmd. close

 

[smedvid]

Got it... It is the simple stuff that kills me... Thanks!!! Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...