I am building a multi page search based on WebThang's 'Car Dealership Search Tutorial'
and having a problem with data entered into MS Access 2002 as a Check Box.
I've modified the search form to look at a recordset for DISTINCT MedicalFC.
MedicalFC is stored in Access as a Yes/No field. As soon as I pick Yes or No
from the drop down on the search form, the search fails. If I leave the selection at 'ALL' (%)
the search passes the correct parameters to the results page. I have tried making the
MedicalFC drop down a "List" instead of a menu....same results.

My question is: What formatting should be applied to the field in Access to have the search work correctly?
and/or how should I setup the search form to deal with these Yes/No fields?

Thanks
Roger

Link to WebThangs Tutorial
www.webthang.co.uk/tuts/tuts_dmx/gk_search1/multisearch1.asp

I think it's

True or False
OR -1 and 0

Thanks