How to check Property of a Closed Form (1 Viewer)

[vtrm]

I have a DB with 20 forms. All of the forms are closed. I opened a new form and added a button. I would like to do the following when the button is clicked:

Check the "Tag" property of each form and count whichever is not null.

Can anybody help me out??:

 

[ozinm]

I think you should be able to spin thorugh all your forms using the allforms collection but I've got a feeling you'll have to get the code to check the .IsLoaded property and if it's false load the form in order to read it's tag.

Tip:
you can use Application.CurrentProject.AllForms in a ForEach statemet to go through them
You can also get the form name using .name property
I'm pretty sure there's an example in Access Help


sorry I haven't got time to bash something together but I haven't got Access on this computer!