surg3mast3r
New member
- Local time
- Today, 03:06
- Joined
- May 13, 2016
- Messages
- 3
I can get a check box to apply a filter when selected and to remove the filter when not selected;
But I don't know how to get it so that if i have two boxes ticked at once it will apply a joint filter. eg. if i had 'high' and 'medium' ticked then it will return all the records that have a priority of high and medium (leaving all the low priority jobs off)
Any ideas?
Code:
Private Sub High_check_Click()
If High_check = True Then
Me.Filter = "Priority = 'High'"
Me.FilterOn = True
Else
Me.FilterOn = False
End If
End Sub
But I don't know how to get it so that if i have two boxes ticked at once it will apply a joint filter. eg. if i had 'high' and 'medium' ticked then it will return all the records that have a priority of high and medium (leaving all the low priority jobs off)
Any ideas?