In Lesson 13 I got the VBA code working perfectly. In Lesson 14 I got the SQL Code to work Perfectly. IN Lesson 15 you showed us how to use a check box to work will Null Values. I took that lesson and Tried to use it a different way. I have 2 Boolean Fields I would like to Filter
I tried to follow the Three way Check box and it works sort of.In my Code

If IsActiveCk = True Then
    If Wh <> "" Then Wh = Wh & "" & AndOrCombo & ""
    Wh = Wh & "IsActive = True"
ElseIf IsActiveCk = False Then
   If Wh <> "" Then Wh = Wh & "" & AndOrCombo & ""
    Wh = Wh & "IsActive = False"
End If

If PolicyCk = True Then
    If Wh <> "" Then Wh = Wh & "" & AndOrCombo & ""
    Wh = Wh & "SignedKeyPolicy = True"
ElseIf PolicyCk = False Then
   If Wh <> "" Then Wh = Wh & "" & AndOrCombo & ""
    Wh = Wh & "SignedKeyPolicy = False"
End If

If IsActive is True or False and SignedKeyPolicy is Null the filter works

If Is Active is Null and SignedKeyPolicy is True or False the filter works

If Active and Signedkeypolicy are both Not Null then I get a Enter Parameter Value "TrueANDSignedKeyPolicy" What code am I missing to get to filter if both have a value in them?

---

Reply from Richard Rost:

You're missing spaces inside your quotes.