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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top