checboxes in Access -- would like to be able to check several checkboxes

  • Thread starter Thread starter Deborah Ellis
  • Start date Start date
D

Deborah Ellis

When you create a drop-down list in a table or form, you
can only pick one of the things in the list and that
shows up in the form or report or table. But what if you
want to be able to check more than one of the options in
the list and have all of your checked options show up?
For example, suppose I am filling out a form that asks
what my race is, and here are the choices: white, black,
asian, hispanic, other. Suppose I want to check white
AND asian and I want them both to show up. How do I do
this?
 
With a combo box (the proper name for a drop-down list), you have no option:
combo boxes only allow you to select one item at a time. If you use a list
box instead, you can set it to Multiselect, then parse through the list box
to determine which items have been selected. (see
http://www.mvps.org/access/forms/frm0007.htm at "The Access Web" for one
approach)
 
Back
Top