need to check if form is open

[Pouncer]

e.g

if Form1 is open then Unload Form1
if Form7 is open then Unload Form7

etc, any ideas how?

[vincentg]

You can see it using loop thru the Forms Collection...
Then unload it..

I think somebody few hours ago posted something like that here...

[RhinoBull]

Check my replies in this thread .

[dglienna]

Here it is...

Option Explicit
 
Private Sub Form_Activate()
  Dim frm As Form
  For Each frm In Forms
    If frm.Name = "Form1" Or frm.Name = "Form7" Then
      Unload frm
    End If
  Next
End Sub

[Pouncer]

thanks, could i put that code in a module and do

Call Form_Activate in the function of my form?

[Hack]

thanks, could i put that code in a module and do

Call Form_Activate in the function of my form?

Form_Activate is an event in all forms and fires when the form is loaded.

The question is: at what point in your application do you need to know whether these forms are still loaded?

[RhinoBull]

Form_Activate is an event in all forms and fires when the form is loaded. ...

You meant to say Activated, didn't you Hack?