After Form Load, but before Form Activate? Runs Once

[drewson]

I'm trying to set up a form that automatically begins a sub as soon as it appears onscreen (thus I thought of using the Paint event), and shows a status indicator moving up, etc. But if I click off, then click back on, the process starts over again because the form is repainted.

How can I start the sub once so I can view the status indicator and then not have to worry about it starting over again when the form is repainted or activated?

Thanks!
Drew

 

[chrissie1]

set a counter when it's more then once don't paint.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting