Mutliple filters on a subform different fields | Access forum

hi guys,
im trying to filter for 2 different fields based on some check boxes.

the issue i keep having is that it applies the first filter and then the second filter rather than both filters in union. please help :(




If Me!Check65 = True And Me!Check71 = True And Me!Check63 = False Then Number = 1
If Me!Check65 = True And Me!Check71 = False And Me!Check63 = False Then Number = 2
If Me!Check65 = False And Me!Check71 = False And Me!Check63 = False Then Number = 3
If Me!Check65 = False And Me!Check71 = False And Me!Check63 = True Then Number = 4
If Me!Check65 = False And Me!Check71 = True And Me!Check63 = True Then Number = 5

Select Case Number
Case 1
'credit and Blank Comments
With subfrm
.Filter = "Sector <> 'ABS'"
.Filter = "Comments Is Null"
.FilterOn = True
End With
Me!Check65 = True
Me!Check71 = True
Me!Check63 = False
Case 2
' credit and all bonds