Access Combo Box

[Kay Rude]

Hello!

I am creating a form for our department at the University
of Illinois. The problem that I am having is that one of
my fields is a combo box. I cannot figure out how to
allow the user to make multiple selections from the combo
box (created by using a table). I have been looking and
experimenting, but cannot figure out how to do this!

HELP! PLEASE!

Kay

 

[Jim Allensworth]

Hello!

I am creating a form for our department at the University
of Illinois. The problem that I am having is that one of
my fields is a combo box. I cannot figure out how to
allow the user to make multiple selections from the combo
box (created by using a table). I have been looking and
experimenting, but cannot figure out how to do this!

You can't.

Use a list box instead for multiple selections. Set its Multi Select
property to Simple or Extended.

- Jim

 

[Rick Brandt]

Hello!

I am creating a form for our department at the University
of Illinois. The problem that I am having is that one of
my fields is a combo box. I cannot figure out how to
allow the user to make multiple selections from the combo
box (created by using a table). I have been looking and
experimenting, but cannot figure out how to do this!

Because the option doesn't exist. ComboBoxes don't support Multi-Select,
but ListBoxes do. However; the Multi-Select option for ListBoxes is not
intended to be used as a data entry device. Only for making selections
that will be manipulated in VBA code.

If you are attempting to store multiple pieces of data in a single field
then this is where you've gone wrong. Each field should have at most one
piece of data in it. If you need more than that related to the current
row, then you create another table with a one-to-many relationship to the
first and use a sub-form to make the multiple entries.

 

[Mary]

This will work if you can build some code. I do know how
to do this in Access 97, would you be interested in
learning how? I have not done this in later versions and
do not know if it would work, but would be willing to
share what I know.