Checking for subforms on a form

[James Martin]

What is the best way to check in VBA for all the subforms on a form? I can
cycle through all the controls on the form checking for
ControlType=acSubForm. But some of my forms have a massive number of
controls and I'm wondering if there is a more efficient way.

Thanks in advance.

James

P.S. I suppose I could also cycle through the forms collection looking for a
form with my form as the parent, but I suspect that will be slow.

 

[Guest]

You'd need to show us the code...but it sounds like you are doing it ok.

 

[Douglas J. Steele]

I believe that what you're doing is the only way.

You can't cycle through the Forms collection looking for forms with your
form as a parent because subforms don't get added to the Forms collection.