Multiple Selections from combo box

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

I have a memo field I would like to populate like a combo
box. However I would like to be able to make several
choices from the list to populate the field not just one.

Any Ideas?

I have tried pull up a form with the choices I would like
and by using macros transfering the text from the control
source in the second form into the memo field on the
original form.

Any suggestions would be greatly appreciated.
 
Sorry: combo boxes don't support Multiselect. Your only choice is to use a
list box.
 
Stefan said:
combo

List Boxes only seem to allow one choice plus I cannot
alter the field I can only choose from the list.

Is there any other way to populate a memo field by pulling
text from another table?
Click to expand...

Listboxes have a Multi Select property that's set to None by default. You
can change it to either Simple (which allows you to select contiguous rows
by clicking on the first row, holding down the shift key and clicking on the
last row) or Extended (which allows you to select non contiguous rows by
holding down the Ctrl key while clicking on each row)

To retrieve the rows that you've selected, use code like:

Dim varItem As Variant

For Each varItem In Me!MyListbox.ItemsSelected
strSelected = strSelected & Me!MyListbox.ItemData(varItem) & vbCrLf
Next varItem

(where I'm assuming the name of the list box is MyListbox in the code above)
 
Back
Top