Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to find out if a form is open... 2
- Thread starter herb8
- Start date
-
1
- #2
"Learn from others' mistakes. You could not live long enough to make them all yourself."-
1
- #3
Hi,
This will tell you if the form is loaded:
---------------------------------------------------
Dim f As Form
For Each f In Forms
If f.Name = "Form2" Then MsgBox "Yes master, " & f.Name & " at your service."
Next f
---------------------------------------------------
note that loaded is not the same as visible.
If you:
Form2.show
Form2.hide
the form will not be visible, but it will be loaded.
If you want to check if the form is visible use
If f.visible then ...
Sunaj
This will tell you if the form is loaded:
---------------------------------------------------
Dim f As Form
For Each f In Forms
If f.Name = "Form2" Then MsgBox "Yes master, " & f.Name & " at your service."
Next f
---------------------------------------------------
note that loaded is not the same as visible.
If you:
Form2.show
Form2.hide
the form will not be visible, but it will be loaded.
If you want to check if the form is visible use
If f.visible then ...
Sunaj
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
