I am attempting to create a triple set toggle button to allow the end user to visualize data based on criteria. I would like them to have the ability to visualize
1. All records
2 Required Records
3. Not Required Records
but using the toggle button. I have created the toggle button and the toggle buttons by default are set to Null, True, and False. I am trying to reset the original default value to all. Ideas?
I also changed to color and captions below and should read something like this: Just stuck on how to get all and not null.
Any help would be appreciated.Code:Private Sub TogRequired_Click() If IsNull(Me.togRequired.Value) Then ' Me.togRequired.value = Me.togRequired.Caption = "All" Me.togRequired.BackColor = 16 ElseIf togRequired.Value = True Then Me.togRequired.Caption = "Yes" Me.togRequired.BackColor = 10 ElseIf Me.togRequired.Value = False Then Me.togRequired.Caption = "No" Me.togRequired.BackColor = 0 End If End Sub