WineSnob
Not Bright but TENACIOUS
- Local time
- Today, 12:52
- Joined
- Aug 9, 2010
- Messages
- 211
I have a procedure to filter and create a query. One of the fields is a checkbox. The code below works and filters whether the control is True or False. The questions is what do I do if want to see all records True and False.
' Check for LIKE Paid
If Me.chkPaid < 1 Then
varWhere = varWhere & "[Received] LIKE """ & Me.chkPaid & """ AND "
End If
' Check for LIKE Paid
If Me.chkPaid < 1 Then
varWhere = varWhere & "[Received] LIKE """ & Me.chkPaid & """ AND "
End If