I tried it and it still shows every record. the way that i'm filtering my form is:
Dim test1 As String
test1 = "SELECT Probs.IssueCategory, Probs.ProblemID, Probs.Description, Probs.Comments," & _
" Probs.Status, Probs.IssueCategory, Probs.[Product Line], Probs.Assigned, Probs.[LOE/SRD], Probs.[Legacy/Epic] " & _
"FROM Probs " & _
"WHERE (((Probs.IssueCategory)='" & strCL & "' OR (Probs.IssueCategory)='" & strME & "' OR (Probs.IssueCategory)=" & _
"'" & strVE & "' OR (Probs.IssueCategory)='" & strCR & "' OR (Probs.IssueCategory)='" & strPAR & "') AND " & _
"((Probs.Status)='" & strCLOSED & "' OR (Probs.Status)='" & strOPEN & "' OR (Probs.Status)='" & strHOLD & "') AND " & _
"((Probs.[Product Line])='" & strRADAR & "' OR (Probs.[Product Line])='" & strRADIO & "' OR " & _
"(Probs.[Product Line])='" & strSATCOM & "') AND ((Probs.[LOE/SRD])='" & strLOE & "' " & _
"OR (Probs.[LOE/SRD])='" & strSRD & "')) " & _
"ORDER BY Probs.Assigned;"
RecordSource = test1
Assigned.FontWeight = NORMAL
Priority.Visible = False
PrioritySeq.Enabled = False
ProblemID.FontWeight = NORMAL
ListingBy.Caption = "CL Status"
When i put the code you suggested in the report code or in the code for the report button it doesn't filter. If do your first suggestion it asks me for a parameter. The filter above has a bunch of strings. each string is set through more code when a checkbox is checked. if a value does not need to be searched for, it's string will be set to something that is being looked for.