123dstreet
Registered User.
- Local time
- Today, 02:02
- Joined
- Apr 14, 2010
- Messages
- 122
Hello,
I have a continuous form that shows all the records from TableA. In the form header I have added multiple filtering options using either text or combo boxes. Each filter uses the following VBA executed by a button:
The filters work fine one at a time, but is it possible to run FilterA, then in the header choose a different filter, FilterB, and run it to further filter down the records?
I have a continuous form that shows all the records from TableA. In the form header I have added multiple filtering options using either text or combo boxes. Each filter uses the following VBA executed by a button:
Code:
Me.Filter = "[Priority] Like" & "'" & Me.Combo94 & "*" & "'"
If IsNull([Me.Combo94]) = False Then Me.FilterOn = True Else Me.FilterOn = False
SendKeys "+{Down}"
The filters work fine one at a time, but is it possible to run FilterA, then in the header choose a different filter, FilterB, and run it to further filter down the records?