Using two combo boxes to filter a split table

[Hursan]

I have a split form I want to filter using two Combo Boxes:
First by Department (DepartmentCombo) then by Date (JulianComboBoX). When I select a department from the DepartmentCombo, I see my filtered options under the JulianComboBox, but when I select a date from the JulianComboBox, the list unfilters the Departments and shows me everything that matches the JulianComboBox selection.

For example, when I select department HOS from the DepartmentCombo the JulianDateCombo shows me a filtered list, but when I select let’s say date 262, the split table refreshes and shows me everything that matches date 262 from all departments not just from department HOS.

This is the DepartmentCombo Query/RowSource

SELECT ListByDepartmentQuery.Dept
FROM ListByDepartmentQuery


GROUP BY ListByDepartmentQuery.Dept, ListByDepartmentQuery.Dept
ORDER BY ListByDepartmentQuery.Dept;

This is the Private Sub DepartmentCombo_AfterUpdate()
Me.Filter = "[Dept]= " & Chr(34) & Me.DepartmentCombo & Chr(34)
Me.FilterOn = True

This is the JulianComboBox Query/RowSource

SELECT ListByDepartmentQuery.Dept
FROM ListByDepartmentQuery
GROUP BY ListByDepartmentQuery.Dept, ListByDepartmentQuery.Dept
ORDER BY ListByDepartmentQuery.Dept;

This is the Private Sub JulianComboBoX_AfterUpdate()
Me.Filter = "[JulianDate]= " & Chr(34) & Me.JulianComboBoX & Chr(34)
Me.FilterOn = True
Me.DepartmentCombo.Requery

Any help is greatly appreciated. Thanks in advance

[Welshgasman]

So you need to combine the filters, not swap one for the other?

[June7]

Review http://allenbrowne.com/ser-62.html