Select all records that match filter

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
 
Solved the problem using 3 option buttons.
 

Users who are viewing this thread

Back
Top Bottom