[AccessD] Check Only One

Virginia,

If you use an option group I think you'll find the functionality you are 
looking for.  Regardless of which was checked...you selection is always 
stored in the same field.

Good Luck,

Mark A. Matte


>From: "Hollis, Virginia" <hollisvj at pgdp.usec.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessD at databaseadvisors.com
>Subject: [AccessD] Check Only One
>Date: Mon, 23 Oct 2006 10:39:49 -0500
>
>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

_________________________________________________________________
Get today's hot entertainment gossip  
http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001