How to do Multiselect for drp dn box in table?

  • Thread starter Thread starter Andreea
  • Start date Start date
A

Andreea

do you know if there is a way to select multiple items
from a drop down list (like using the ctrl or shift key)
for a particular column and have them associated (stored)
with that row in the table? (verses just one item from the
list being stored for that particular column in that row)
The source type is Table/Query. Row Source is from a
column in the querried table.
 
My guess is that you are talking about ComboBox and in ComboBox, you can
only select 1 item.

You probably want a Multi-Select ListBox but you will need to write VBA code
to handle the Multi-Select ListBox Properly. Also, don't store
multiple-items in a single Field value.
 
Andreea said:
do you know if there is a way to select multiple items
from a drop down list (like using the ctrl or shift key)
for a particular column and have them associated (stored)
with that row in the table? (verses just one item from the
list being stored for that particular column in that row)
The source type is Table/Query. Row Source is from a
column in the querried table.
Click to expand...
 
Back
Top