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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Knowing which Forms are LOADED
- Thread starter bnath001
- Start date
Use the Forms collection.
Loop through the Forms collection with either a For..Each or For...Next loop.
For I = 0 To Forms.Count - 1
do something with Forms(I).<property>
Next I
Or
Dim frmForm as Form
For Each frmForm in Forms
do something with frmForm
Loop through the Forms collection with either a For..Each or For...Next loop.
For I = 0 To Forms.Count - 1
do something with Forms(I).<property>
Next I
Or
Dim frmForm as Form
For Each frmForm in Forms
do something with frmForm
- Thread starter
- #3
I tried using your code
For i = 0 To Forms.Count - 1
'do something with Forms(I).<property>
MsgBox "hello this is " & Forms(i)
Next i
I would like to know the name of the form which is opened.
when the control reaches the Msgbox statement, there is no property.
any help please.
thanks
nath
For i = 0 To Forms.Count - 1
'do something with Forms(I).<property>
MsgBox "hello this is " & Forms(i)
Next i
I would like to know the name of the form which is opened.
when the control reaches the Msgbox statement, there is no property.
any help please.
thanks
nath
- Status
Similar threads
