navigating controls in control tabs/subforms

[john431]

I'm having a bit of trouble referring to a control in a subform within a tab
control. Without the tab control, I would code it as Forms![Main
Form]![Subform control].Form![Control name].

However, the subform control is within a 4 page tab control. Each page has
a different subform. How do I refer to a control in a subform on one of the
control tab pages?

Any suggestions would be appreciated.

John431

 

[John Spencer]

The same way as if the tab control did not exist.
Forms![Main Form]![Subform control].Form![Control name]

If you want to confirm this try creating two controls with same name of
different pages of the tab. You'll get an error message when you try to
name the control on page 2 the same as the control on page 1.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[john431]

Thank you for the response, John.

I have tried that and I have also tried:

Forms![Main Form]!Pages![Page1]![Subform control].Form![Control name]
Forms![Main Form]![Subform control].Form!Pages![Page1].[Control name]
Forms![Main Form]![Subform control].Pages![Page1]!Form![Control name]

None of these 4 combinations work. The error message is that the Main Form
cannot be found.

John431

The same way as if the tab control did not exist.
Forms![Main Form]![Subform control].Form![Control name]

If you want to confirm this try creating two controls with same name of
different pages of the tab. You'll get an error message when you try to
name the control on page 2 the same as the control on page 1.



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I'm having a bit of trouble referring to a control in a subform within a
tab
control. Without the tab control, I would code it as Forms![Main
Form]![Subform control].Form![Control name].

However, the subform control is within a 4 page tab control. Each page
has
a different subform. How do I refer to a control in a subform on one of
the
control tab pages?

Any suggestions would be appreciated.

John431