code running on open of a form 1

[brightstar]

Quick question.
How or at what point can i insert code into a form so that it runs only when the form has opened and become visible.

 

[JohnYingling]

I use Activated Event and a module level boolean indicator to know that it is the first time.

if not mblnInitialized then
....one time code
mblnInitialized = true
End if

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[icca]

you can also use the form's on load-function or put it in the construct (public sub new()).

/icca

 

[brightstar]

i ended up using a timer to get the job done. I tried using the activate event but it ran over and over. nice idea on the boolean. i'll get it sorted with that im sure. cheers.