How to do Multiselect for drp dn box in table?

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.
 
V

Van T. Dinh

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.
 
Z

zfidjili

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

Top