strWhere when field is Boolean

[fishtek]

I would like to use strWhere to search a boolean field. Can someone provide me with the proper syntax?
See similar code below.

Dim strWhere As String
strWhere = "1=1"
If Not IsNull(Me.chkPaid) Then
strWhere = strWhere & " AND [Paid] Like  """ & Me.chkPaid & """ "
End If
Dim stDocName As String
stDocName = "frmNOVSearch"
DoCmd.OpenForm stDocName, acFormDS, , strWhere

End Sub

Thanks for any help.

 

[PHV]

Like this ?

If Not IsNull(Me.chkPaid) Then
  strWhere = strWhere & " AND [Paid]=" & IIf(Me.chkPaid, "True", "False")
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

hi,

SEARCH? You can SELECT a boolean field or assign a criteria to a boolean field. I'm assuming that Me.chkPaid is True/False

Dim strWhere As String
strWhere = "1=1"
If Not IsNull(Me.chkPaid) Then
  strWhere = strWhere & " AND [Paid] = " & Me.chkPaid 
End If

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}