Please help

[Paul Milner]

Hi
I am not sure if this is the right newsgroup.
I have created an access database from a form I created
in FP2003 I have run the database results wizard and
added the add search form option.
In my form and database I have three check box fields
MALE,FEMALE and BOTH.
In the results table I would like a catagory which says
gender and I whould like to type say Female in the
search form and it select the records with only the
female check box
Is it possible to select from multi check boxes with the
same asp search box,or is this a SQL job
Thankyou
Paul M

 

[Thomas A. Rowe]

Why not use radio buttons, since only should be selected, and then assign the actual word value of
Male, Female, Both to the buttons and then write these actual words to the database, then you can
easily search for Male, Female or both. You will need to set the search to exact (=) and not Like,
otherwise a search on Male will return result for both Male and Female.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Guest]

Thanks Thomas
I have come to the conclusion that check boxes are very
anoying and to be avoided
Paul

-----Original Message-----
Why not use radio buttons, since only should be

selected, and then assign the actual word value of

Male, Female, Both to the buttons and then write these

actual words to the database, then you can

easily search for Male, Female or both. You will need to

set the search to exact (=) and not Like,

 

[Thomas A. Rowe]

Checkbox are fine, but requires extra coding to use in a search function.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================