Filtering more than one field on a table & showing all records that match any of the criteria

I have 1 form with a combo box and a subform displaying 4 fields. The combo box is programmed to filter data from 4 fields in the subform. Since I am trying to filter more than one field I am having a problem with access filtering the 4 fields completely out since the filter criteria isn't matching on all four fields at the same time.

Is there a way to program the filter so that it will show a record from field 1 even if all the other 3 fields don't match the same criteria for that record?

NOTE: We cannot use any type of "query" filtering because it does not function with the form/combo box selection setup. This has to be programmed in with VB on the combo box. See code below for how we are currently filtering the subfields.

Start Free Trial

1:
2:
3:
4:
5:
6:

Private Sub Combo2_AfterUpdate()
Dim strFilterName As String
    strFilterName = Me.Combo2
    Me.CPARAssignments.Form.Filter = "InvBy= ImpBy= AudtBy= CPARBy=" & "'" & strFilterName & "'"
    Me.CPARAssignments.Form.FilterOn = True
End Sub