Multiple Selections

[Guest]

I am setting up a form that will have a few either drop down boxes or list
boxes that I would like to have the ability to select and save more than one
choice. One can I set up a combo box or list box that allows multiple
selections and if so what is the best way to save the selections. Thanks - Len

 

[Guest]

1. You can perform multi select with a list box, but not with a combo
2. You can't store in the table more then one selection.

The best way to store one selection will be to bound the form to a table,
and then bound the ListBox/combo to a field in the table

 

[Guest]

What would you suggest as the best way to develop this application when the
requirement is the ability to allow choosing more than one. The only way I
could think of would be to have a subform for each field that requires this
ability. Thanks

 

[Guest]

Yes, sub form with a seperate table, will be the right solution for multi
data entering, when one of the fields is a combo that used for selection for
each record
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

 

[BruceM]

Please don't be put off by the idea of using a table for each category that
could have several choices. A small table related to the main table is a
pretty simple thing to implement once you get used to it. Once you have
made one subform you can copy it and assign a different record source to the
subform and the controls. I think you will be pleased by the flexibility
this approach allows.

 

[Karen]

I have a similar problem and need help to resolve. This is somewhat helpful
but I need more clarification -
I have a employee in one table with a list of "jobs" in a seperate table. I
also included in the "Employee" table a field called JOB that is linked to
the "Jobs" table. I want via the form for someone to select the employee and
the jobs they are assigned. Most times, more than one. I need to later
report on it. How can I do this if multiple selections are not stored in
tables? Since the data is being entered via the form. HELP!