I am creating a form that has several unbound checkboxes. The user will select any of the check boxes and it will display only the "NULL" Values for that selected checkbox.

The code below is showing the opposite. It is displaying non null values.


HTML Code:
Dim vartest As Variant
    vartest = Null
    If NOT IsNull(Me.chkInitiatedbyID) Then
        varWhere = (varWhere + " AND ") & "[InitiatedbyID] " & Me.chkInitiatedbyID
    End If

    If (DLookup("NcrNumber", "qryNullReport", varWhere)) Then
       Exit Sub
End If