retrieving records for report

[jimbo62]

I have a form that takes input from many fields and modifies the underlying query. I have this code for selecting a criteria based on a check box value.

This statement brings back a "Type mismatch" all fields are text ...

If (Me![ChkNODY]) = True And (Me![ChkNODN]) = True And (Me![chkNODX]) = False Then
sWhere = sWhere & " and qryEx_CauseByNOD.[NOD] = '" & "Y" Or "N" & "'"
End If

I want to be able to use an or statement to get 2 valuses returned.


Any Suggestions???

Thanks Jim