I have a split-form that I am trying to filter with two different combos, but am struggling a little bit.
The first combo filters the sheet by a project managers name. I then want the second combo to filter those results by type.
My first filter works fine to get it to show specific PM's.
How do I then add a second combo to then filter those results one step further? The field in question is [Job Type] and it has 4 static values (Combination, Switchgear, Lighting, Miscellaneous). So I would select which PM to filter it by, then filter those results by one of the job arch-types. So an example would be I filter it to the PM John. I then filter it to see all Switchgear job types John has.
The first combo filters the sheet by a project managers name. I then want the second combo to filter those results by type.
My first filter works fine to get it to show specific PM's.
Code:
Dim strfilter As String
Me.Refresh
strfilter = "[Project Manager Name] like '*" & Me.PMFilterCmb & "*'"
Me.Filter = strfilter
Me.FilterOn = True
How do I then add a second combo to then filter those results one step further? The field in question is [Job Type] and it has 4 static values (Combination, Switchgear, Lighting, Miscellaneous). So I would select which PM to filter it by, then filter those results by one of the job arch-types. So an example would be I filter it to the PM John. I then filter it to see all Switchgear job types John has.