I have text boxes on a form which uses radio buttons to switch between different views.
I want the text in the boxes to change depending on the button chosen. I triedusing this code but its not working
Private Sub Optionsbutton_click()
Select Case Me.Optionsbutton
Case 1
Me.box1.Visible = False
Me.box2.Visible = False
Case 2
Me.box1.Visible = True
Me.box2.Visible = True
Case 3
Me.box1.Visible = True
Me.box2.Visible = True
End Select
End Sub
Private Sub optionsbutton_AfterUpdate()
Select Case Me.optionsbutton
Case 1
Me.txtBox = "list of Departments"
Case 2
Me.txtBox = "list of Employees"
Case 3
Me.txtBox = "list of Clients"
End Select
End Sub
the on click part works fine. Only the afterupdate part doesn't work.
I will appreciate any help