Is a form loaded ?

[joefoulkes]

Whats the easiest way to check if a form is loaded or not ???


Thanks

[sebs]

In your form load put a boolean variable and set it to true
, and then do if var = true then form is loaded.

Dim isLoad as Boolean

Private sub Form_load()
isLoad = True
End sub

Try it, maybe that will make it!!!

[joefoulkes]

Its okay, this works...

For i = 0 To Forms.count - 1
If Forms(i).name = myform Then Unload myform
Next i

Dim bFormLoaded As Boolean

Private Sub Form_Load()

    bFormLoaded = True

End Sub

Private Sub Form_Activate()

    If Not bFormLoaded Then Exit Sub
    
End Sub