Referece a value in a Tab of a Form within a SubForm

[AccessARS]

Not sure if the subject makes sense but I have Form1 that has a Subform1 with
a control source of Form2 which has a Tab Control (TabCntrl1) with three tabs
(Tab1, Tab2, Tab3). Tab2 has a Combo box (Combo1) and I would like to
reference the value of Combo1 through the vba code running from my open Form1.

This is as close of I've reached to Combo1 in Tab2 from my Form1 VBA code...

Form_Form2.Tab2

....but I can't see Combo1 in the options of TAB2 ??


Please help!

 

[Jeanette Cunningham]

Hi AccessARS,
leave the tab control out of the reference completely.
Me.[subform 1].form.[Combo 1]


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[AccessARS]

I can't believe the amount of time I spent on this...you are the best.
THANK YOU! THANK YOU! THANK YOU!

Hi AccessARS,
leave the tab control out of the reference completely.
Me.[subform 1].form.[Combo 1]


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Not sure if the subject makes sense but I have Form1 that has a Subform1
with
a control source of Form2 which has a Tab Control (TabCntrl1) with three
tabs
(Tab1, Tab2, Tab3). Tab2 has a Combo box (Combo1) and I would like to
reference the value of Combo1 through the vba code running from my open
Form1.

This is as close of I've reached to Combo1 in Tab2 from my Form1 VBA
code...

Form_Form2.Tab2

...but I can't see Combo1 in the options of TAB2 ??


Please help!