Milothicus
Registered User.
- Local time
- Today, 11:28
- Joined
- Sep 24, 2004
- Messages
- 134
I'm running a search query, and depending on the state of a check box. the check indicates wether or not a user wants 'lost jobs' (meaning bid not accepted) to be included in the search.
fLstSrch is in the criteria for the 'order lost' column in the search. it passes the value fine, and if it's 0, it works fine, but i can't get it to include all records.
I've tried:
"0 Or -1"
"=0 or = -1"
=0 or -1"
""
"*"
and others, i'm sure. i can't get it to work. any recommendations?
Public Function fLstSrch(optVal)
If optVal = 0 Then
fLstSrch = "0"
ElseIf optVal = -1 Then
fLstSrch = "0 Or -1"
End If
End Function
fLstSrch is in the criteria for the 'order lost' column in the search. it passes the value fine, and if it's 0, it works fine, but i can't get it to include all records.
I've tried:
"0 Or -1"
"=0 or = -1"
=0 or -1"
""
"*"
and others, i'm sure. i can't get it to work. any recommendations?
Public Function fLstSrch(optVal)
If optVal = 0 Then
fLstSrch = "0"
ElseIf optVal = -1 Then
fLstSrch = "0 Or -1"
End If
End Function