SQL and Checkboxes

[rat_b76]

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;

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