SQL and Checkboxes

rat_b76

Registered User.
Local time
Today, 17:57
Joined
May 20, 2003
Messages
37
Hi All,

I am trying to figure out how to get a search form to select all records where the check box is false (or true) and am having some trouble.

I have tried having all sorts of combinations;

Code:
strWhere="Where Request.ReqComplete=False"
strWhere="Where Request.ReqComplete=-1"

However, am not having any luck, can anyone help?

ps. I cannot use the filter on load event as I use the same form to search for Current, Approved and Declined Requests.

Regards
Rat_b76
 

Users who are viewing this thread

Back
Top Bottom