Run a Macro Once after timer

[webjunk]

What do I need to do if I want to run a macro 10 seconds after I open a form. I tried the Timer Interval but it keeps running the macro every 10 seconds.

Thanks in advanced

 

[mrf1xa]

One way is to run a line of code after your macro has run the first time, along the lines of Me.TimerInterval = 0.

you will need to add a similar line to the forms OnOpen event to reset the timer to 10secs (remember that the timer interval is shown in milliseconds...)

HTH

Nigel Nigel
Didn't someone say work is supposed to be fun? They didn't have computers then I guess....