Running code after form load

[shragel]

How can I execute code after form load is finished and the form is visible.

[Arbiter]

In the form_Activate maybe? I don't have VB in front of me so it's just an educated guess....

[shragel]

But i dont wabt to execute the code every time the form activates.

[spetnik]

Well, if you call the .Show method of the form in the load event, it will display the form before running anything else. You may want to add a DoEvents after calling show, though.

[shragel]

yasher kochachem ich hob es nisht gevist

[spetnik]

Boruch Tehiyeh

[ELampman]

Sub Form_Load()

....Other code here

Me.Show

Call MySub

End Sub

[shragel]

But why cant the user click anything till the end sub of form load executes

[spetnik]

Originally posted by spetnik
Well, if you call the .Show method of the form in the load event, it will display the form before running anything else. You may want to add a DoEvents after calling show, though.

Do I hear an echo???