subform in a collection

[BoSoxFan]

I'm trying to disable controls on a subform during runtime. However, when I check the forms collection in the Immediate window, only the main form is there. Is there something weird about loading subforms into a collection?

 

[jebry]

Hi!

Subforms are not part of the forms collection. To get at the controls of a subform use the following:

Forms!MainForm!SubformControlName.Form.ControlName.Property

hth
Jeff Bridgham
bridgham@purdue.edu

 

[BoSoxFan]

Wow - thanks for the quick response! I'll give your recommendation a try.

Happy New Year