title: Show/Hide tab page from a combo box on a subform
body: <p>I have been looking around the internet for ages trying to find this solution to a problem i've been having. </p>
  
  <p>I have a form (Form1) which consists of tabs and a subform (subForm1). Within subForm1 I have a combo box which I want to assign an AfterUpdate Event to. If the combo box (in the subform) is yes, show tab1, else if combo box is no then hide tab1. The code I'm looking for is something like this :</p>
  
  <pre><code>Private Sub Combo52_AfterUpdate()
  If Me.Combo52.Value = "Yes" Then
  Forms!FrmAssessment.TabCtl50.Pages(5).Visible = True
  ElseIf Me.Combo52.Value = "No" Then
  Forms!FrmAssessment.TabCtl50.Pages(5).Visible = False
  End If
  </code></pre>
  
  <p>Got any ideas?</p>