trying to reference tab on subform (1 Viewer)

I have a field I need to reference from my subform's tab's control to my main form like:

If MainForm.... Tab... Control = 2 Then
Mainform.Label1.Visible = True

Here are the names of the forms/controls in their hierarchy:

frmMain
frmSubFormCosts
tabFurniture
txtValue

what would be a syntax that would work? Thanks! Benny

This link may help: http://theaccessweb.com/forms/frm0031.htm
FYI, all controls on tab controls have unique names and you reference them as if the tab control was not even there.

Tabs do not alter the way a control is referenced. What will alter the reference is whether the tabs contain subforms or not.

You will need to control the main form from the subform not vice versa. If the code is placed in the main form, it will run in the mainform's Current event most likely. However, the subform shows multiple records so exactly which subform record did you want to reference?

Use the subform's Current event or AfterUpdate event or possibly both to alter the visible property of the main form control and you just need to use the Me.Parent reference.
As you click through the subform going record to record, the label on the main form will change to reflect the value in the CURRENT subform record.

on the frmMain form you can check if TabControl->Page 2 is selected:

Private Sub Form_Current()
' Label1 refers the Label control to hide
' in the frmMain
Me.Label1.Visible = (Me.TabControl0.Value <> 2)

End Sub


Now on the Change Event of your TabControl:


Private Sub TabControl0_Change()
Call Form_Current
End Sub