[AccessD] Check Only One

Virginia,

A different approach, since they can only check one, is to use a combobox.
I almost always use these because they take less space, are easily
changeable by just changing the data in the lookup table, and can be
selected by the user more quickly without using the mouse.  

If you put a cbo.DropDown method into the Enter event for the combobox, it
will display the choices as the user tabs in.  Then they just begin typing
to select the one they want, and tab out.

If a user selects other, then a required Other Description field can be used
to get that information, which is often useful for reporting.

Hope this helps!

Dan Waters

-----Original Message-----
Subject: Re: [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

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