363,927 Members | 2703 Browsing Online
Community for Developers & IT Professionals
Bytes IT Community

Multiple selection from the list box or combo box

tara99
100+
P: 106
Is it possible to select multiple items from a list or Combo box?

If yes then how?

Thanks
Oct 24 '06 #1
Share this Question
Share on Google+
3 Replies


Tanis
100+
P: 143
Not from a combo box, but you can from a list box. There's a property on the list box called Multi Select. Change that to Simple.You wiil obvously need code somewhere to carry out the instructions. Depends on what you want to do.
Oct 24 '06 #2

MMcCarthy
Expert Mod 5K+
P: 8,068
Is it possible to select multiple items from a list or Combo box?

If yes then how?

Thanks
ListBox only

In properties window go to the other tab and set Multi Select to Simple

Then you can use the following code somewhere:

Expand|Select|Wrap|Line Numbers
  1.  
  2. Dim tmpItem As Variant
  3.  
  4. For Each tmpItem In listBoxName.ItemsSelected
  5.  
  6. ' do something
  7. ' reference each object individually using
  8. <something> = listBoxName.ItemData(tmpItem)
  9.  
  10. Next tmpItem
  11.  
  12.  
Oct 24 '06 #3

Gobi nath
P: 16
not possible in combobox , but in listbox allow to select
Feb 10 '12 #4

Post your reply

Help answer this question



Didn't find the answer to your Microsoft Access / VBA question?

You can also browse similar questions: Microsoft Access / VBA