How do I know whether a form is open

[aziz rasul]

How do I obtain a list of forms that are OPEN?

 

[Rich]

Try the function Harry posted here
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30167

 

[Howlsta]

You could try something like this, depends where you want the names displayed I guess...

Dim I ' Declare variable.
Dim names

For I = 0 To Forms.Count - 1
names = names & Forms(I).Name & " "
Next I

MsgBox names, vbOKOnly, "Forms"
End Sub

Rich

 

[aziz rasul]

Thank you ALL.