C
cmichaud
I am using a combo box to hide or show tab pages. I have what is below
set up so far and it is working fine. The problem is i have another
combo box following this one. And i dont know how to incorporate it.
It has two choices: active or inactive. For both cases (6 and 7) if
the member is active i want to still display [club membership] if they
are inactive i want to hide it. Does anyone know how i do this. i am
truly stuck. tks. caleb
in the forms current event
Me![Personal Info].Visible = True
Me![Additional Info].Visible = False
Me![Medical].Visible = False
Me![Contacts].Visible = False
Me![Training].Visible = False
Me![History].Visible = False
Me![References].Visible = False
Me![Club Membership].Visible = False
In the after update event
Select Case PositionID
Case "6"
Me![Medical].Visible = True
Me![Contacts].Visible = True
Me![Training].Visible = True
Me![Club Membership].Visible = True
Case "8"
Me![Additional Info].Visible = True
Me![Training].Visible = True
Me![History].Visible = True
Me![References].Visible = True
Me![Club Membership].Visible = True
set up so far and it is working fine. The problem is i have another
combo box following this one. And i dont know how to incorporate it.
It has two choices: active or inactive. For both cases (6 and 7) if
the member is active i want to still display [club membership] if they
are inactive i want to hide it. Does anyone know how i do this. i am
truly stuck. tks. caleb
in the forms current event
Me![Personal Info].Visible = True
Me![Additional Info].Visible = False
Me![Medical].Visible = False
Me![Contacts].Visible = False
Me![Training].Visible = False
Me![History].Visible = False
Me![References].Visible = False
Me![Club Membership].Visible = False
In the after update event
Select Case PositionID
Case "6"
Me![Medical].Visible = True
Me![Contacts].Visible = True
Me![Training].Visible = True
Me![Club Membership].Visible = True
Case "8"
Me![Additional Info].Visible = True
Me![Training].Visible = True
Me![History].Visible = True
Me![References].Visible = True
Me![Club Membership].Visible = True