Disable tab in subform based on check box

[russdwright]

I have a subform with multiple tabs:

• Discovery
• Questionnaire
• Third Party
• Documentation
• Transition
• Turnover

I have a couple of questions in Questionnaire that, upon being answered, should enable certain tabs (Third Party and Documentation) respectively. Unfortunately, my research via Google has not really garnered any solid results. Based on what I have found, this does not appear to be possible.

[RuralGuy]

What have you tried and where do you have this process? Are the questions on the Main Form? Have you seen this: http://theaccessweb.com/forms/frm0031.htm

[russdwright]

Option Compare Database
Private Sub Ctl3rdParty_Click()
If chk3rdParty.Value = True Then
Third_Party.Enabled = True
ElseIf chk3rdParty.Value = False Then
Third_Party.Enabled = False
End If
End Sub

[RuralGuy]

Where is this code located? Is it on the Main Form or the Sub Form?

[russdwright]

The checkbox is on the subform. Specifically, it's on a checkbox in the Questionairre tab of the subform. Third Party is another tab in the subform.

[RuralGuy]

Try:

Me.Third_Party.Enabled = Me.chk3rdParty