[AccessD] Check Only One

Virginia,
If you create a frame and put the checkboxes or radio buttons in a frame I think this restricts input to only one choice, what you can then do is assign each choice a value (say 1-4) and store the value in a field.

Then you have a table of your choices with two fields, one for the value and one for the text:
Value          Text
1                 Drill
2                 Injury
3                 Fire
4                 Other

then when you do your query, link your main table with the value field, into your value field, and get it to display the description.

Sorry if I haven't made myself clear but am just leaving work....if you need any further info, contact me here or offline.

Paul Hartland





Message Received: Oct 23 2006, 04:45 PM
From: "Hollis, Virginia" 
To: accessD at databaseadvisors.com
Cc: 
Subject: [AccessD] Check Only One

I am creating a new database / form for tracking incidents. The form has
4 checkboxes and a text field for Other. They are supposed to only check
one. How do you set that up on the form so they can only check one of
the boxes, not more than one?



Also, I am not sure how to do the tables. Should there be a field for
each check? (Drill, Injury, Fire, Other). If not, how would reports show
which one was checked?



So, is there a way to force only once checkbox at a time without going
through each field & determine - If drill is checked, the rest aren't,
etc.



Virginia

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





Paul Hartland 
paul.hartland at fsmail.net 
07730 523179