Check if the subform is opening

[accessman2]

Hi,

''this is for checking if the form1 is opening
If CurrentProject.AllForms("form1").IsLoaded = True Then
.....................
End If

how do we check if the subform is loading on the form1?

currentproject.allforms![form1]![subform1].isloaded

How to fix it?

 

[llkhoutx]

Checks the Access forms collection (for open forms):

dim frm as form
for each frm in forms
'frm.name is the name of an open form
next

Note that the forms container is all forms, e.g.

dim doc as document
for each doc in currentdb.containers!forms.documents
'doc.name is the name of a database form
next