Multiple Selections

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
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.
 
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!
 
Back
Top