Select multiple values from list/combo box - writing to seperate r

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

Guest

I am looking for assistance to do the following combination of actions:

1) I'd like to be able to select multiple entries from a combo or list box
using the CLICK + CTRL/SHIFT key combos (there are also to static fields on
the form)

2) each individiual selections and the 2 static fields need to be written to
a distinct row in a table.

Any assistance would be appreciated.
Thanks,
Dan
 
Forget the combo for this exercise. They are limited to one selection.
You will want a list box with the Multi Select property set to Extended.
To determine what is selected in a MultiSelect list box, see VBA Help for
the ItemsSelected property. It even has a good example of how to loop
through the collection. Then just loop through the collection and add a new
row to your table for each selected item.
 
You must log in or register to reply here.

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

Similar Threads

List box displays values based on multiple combo box selections 2
combo box setup 6
Select Two Values from One Combo 2
Run a query after selecting from combo box 3
Combo box list selection based on earlier selection by user 2
Limiting combo box selection 1
Retain combo box order 1
Combo box returning wrong value 2

Back
Top