Hey, thanks for responding, I tried that but when I do so it ignores my combo box and sorts to the first true boolean it finds with my toggle switch.
So I tried concatenating my filter string to include the combo box value, and the form crashes. This is my VBA for that toggle switch:
Code:
Private Sub Option40_AfterUpdate()
Me.Filter = "Binary_Status = 'ON'" & " AND Reference_Num=" & Me.Reference_Num.Value
Me.FilterOn = True
End Sub
Am I barking up the wrong tree, is there a better way to do this?