Refer to a Subform on a TabControl

  • Thread starter Thread starter Lee T.
  • Start date Start date
L

Lee T.

When I click a command button on a subform, I can get it
to populate the popup form with data from the main form
and subform with no problem. The problem comes in when
the subform is on a TabControl. I cannot seem to
reference the subform then. I have a workaround and that
is to put the subform on the main form and hide it. The
both the hidden subform and the TabControl subform display
the data and when I click on the CMB on the TabControl
subform the reference goes back to the hidden subform.
YUCK!
Is there some magical trick to refering to a control and a
subform that is in a TabControl?

If I refer to the subform this is what I use
=[Forms]![frm_MainInput]![frm_FormA_WTieB]![EventID]

It doesn't work with the SubForm in a TabControl. I tried
putting the tab control in the referal but...

=[Forms]![frm_MainInput]![TabCtl51]![frm_FormA_WTieB]!
[EventID]

tia

Lee T.
 
The tab control is not part of the reference to the subform.
Just use the same reference as you do without the tab control.
 
Back
Top