Changing a tab index when a control has focus
Posted on 2008-10-02
I'll keep this basic. In Microsoft Access VBA, I am designing a form with 3 options, let's call them A, B, and C, that are grouped together, using the radio button control. So, I've got 3 radio buttons.
To the right of my radio buttons, I have a tab control with 3 tabs, each corresponding to an option. When I select option A, I want tab A to be on top. When I select Option B, I would like Tab B to come to the top, and so forth with option and tab C. Also, when one option is selected, the other tabs should be unavailable.
Private Sub optA_GotFocus()
Me.tabA.Enabled = True
Me.tabB.Enabled = False
Me.tabC.Enabled = False
I'm running in circles. I don't know why, with all the resources I have, I can't figure this out. Someone make a suggestion please.