Forms Count

[rm]

"The Forms collection contains all of the currently open forms in a
Microsoft Access database."

So subforms do not show up on the collection.

I have 1 form open with 2 sub forms. The forms collection count
returns 1.

How do I access the sub forms?

 

[strive4peace]

forms!mainformname!subform_controlname.form

WHERE
mainformname is the Name of the main form
subform_controlname is the Name property of the subform control

if you want a specific control on the subform:

forms!mainformname!subform_controlname.form.controlname

Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
have an awesome day
*