I thought that I just posted this question but cannot find it so I'll post again.

On the Open event of a form [frmAvailableHrs], I set properties on the controls of the form's subform [Form3] and it works fine:

Private Sub Form_Open(Cancel As Integer)
Dim ctl As Control

For Each ctl In Forms![frmAvailableHrs]![Form3].Controls
ctl.FontSize = 10
ctl.ColumnWidth = -2
Next

End Sub

I now have a tab subform [sfrmProjectIntakeDetail] that contains it's own subform [Form2] that I need to do the same as above with. I get an error message stating it cannot find the tab subform's subform:

Dim ctl As Control

For Each ctl In Forms![sfrmProjectIntakeDetail]![Form2].Controls
ctl.FontSize = 10
ctl.ColumnWidth = -2
Next

I've also tried adding the mainform name to it with no luck:

For Each ctl In Forms![frmProjectIntake]![sfrmProjectIntakeDetail]![Form2].Controls
ctl.FontSize = 10
ctl.ColumnWidth = -2
Next

Any thoughts on where I went wrong?

Hi

Have a look here for info on how to refer to forms/subforms/sub-subforms

Main forms are accessed through the Forms collection.

Subforms are not, but from your description it sounds like that is what you are trying to do.

A subform is contained in a container control on the form that hosts it, and you access it through the container's Form property.

Forms("formname").SubformContainer.Form.PropertyOrMethod

where formname is the name of your form, SubformContainer is the name of the container control on the form, and PropertyOrMethod is the name of the property or method you are trying to refer to (controls are exposed as properties).

If code is in the host form:

Me.SubformContainer.Form.PropertyOrMethod

Mike

i am working on something similar I think.

I have a subform where I want to hide certain columns based on the month. I am sure that you could substitute any other control type.

Still no luck.

Tried to use this on open event for main form:
For Each ctl In Me![sfrmProjectIntakeDetail]![Form2].Controls - ERROR MESSAGE CAN'T FIND Form2


Tried it this way on open event for main form:
For Each ctl In Forms![frmProjectIntake]![sfrmProjectIntakeDetail]![Form2].Controls - ERROR MESSAGE CAN'T FIND form2
Next


Tried this on open event for subform:
For Each ctl In Me![Form2].Controls - ERROR MESSAGE CAN'T FIND sfrmProjectIntakeDetails

I'm just lost at this point. It works if the Form2 is a subform fo the mainform, but not if it is the subform of the mainform's subform.

If you're saying that your [Form2] is a subform IN A SUBFORM, then you'd need to refer to it with something like (untested):

Forms!YourMainForm!YourSubform1Control.Form!Your2ndSubformControl.Form!YourControlIn2ndEmbeddedForm

Those typos will get you everytime. This is solved, thanks to all who helped.