stevekos07
Registered User.
- Local time
- Today, 06:18
- Joined
- Jul 26, 2015
- Messages
- 174
I want to set up a multi-field filter based on three combobox field selections. I can do this normally, but this one is a bit differend.
Two of the fields are based on selecting True/False fields with names corresponding to the combobox selection, with the criteria as "True", as in the following codes:
And
The third combobox is simple, with a "normal" selection criteria:
The question is, how to I write the code to filter on these three fields?
I only want filtering on "Not Null" fields with empty fields returning all records for that field.
Thanks in advance for your assistance.
Two of the fields are based on selecting True/False fields with names corresponding to the combobox selection, with the criteria as "True", as in the following codes:
Code:
Private Sub cboFilterCategory_AfterUpdate()
With Me
.Filter = Me!cboFilterCategory & " = True"
.FilterOn = True
End With
End Sub
And
Code:
Private Sub cboWeekDay_AfterUpdate()
With Me
.Filter = Me.cboWeekDay & " = True"
.FilterOn = True
End With
End Sub
The third combobox is simple, with a "normal" selection criteria:
Code:
Private Sub cboFilterHub_AfterUpdate()
DoCmd.ApplyFilter "", "[HubLocation]=[Forms]![frmVolunteersSplit]![cboFilterHub]", ""
End Sub
The question is, how to I write the code to filter on these three fields?
I only want filtering on "Not Null" fields with empty fields returning all records for that field.
Thanks in advance for your assistance.