Multiple columns from list box into text string

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

Guest

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?
 
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
 
Back
Top