navigating controls in control tabs/subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
..
 
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
John Spencer said:
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 said:
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
Click to expand...
Click to expand...
 
Hi John,

Forms![name of the main form].Form![name of the subform containing the
control]![Control name]

HTH Paolo

john431 said:
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
John Spencer said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top