Multiple columns from list box into text string

[Jeff Cohen]

I want to create a text string from multiple columns of multiple selections
from a list box. I have a table "Members" with two fields, "Name" and
"Department". I want to select multiple records from that table from a list
box and create a text string that would look like this:

"Name1, Department1; Name2, Department2; Name3, Department3; etc."

I found code which would allow me to do this with the bound column but not
with multiple columns.

Any ideas?

 

[tina]

take a look at the ItemsSelected Property topic in Access VBA Help. it has
sample code for retrieving data from multiple columns in a listbox control.

hth

 

[Jezzepi]

MyTextBox = MyListBox.Column(0) & " " & MyListBox.Column(1) ...