copying multi column listbox data to another multi column listbox

[eric]

Hi,

Can anyone please explain to me how I can cop selected items from a
multi listbox(simple) to another multi listbox?

the code I found on msdn only seems to support single column copies, i
need to copy 3 colums per selection

I was using a for each itm in somelist.itemsselected

and using the rowsource property , but this only gives me the first column

The source listbox is a lookup in a table and the destination listbox is
unbound as I will insert these values programatically.

Any help welcome

[Bas Cost Budde]

the data in other columns sits in the .Columns property of the listbox.
You can put those in the destination box by writing the RowSource
property directly, as a semicolon-separated string of items
(row1item1;row1item2;row1item3;row2item1 etc)

eric schreef:

Hi,

Can anyone please explain to me how I can cop selected items from a
multi listbox(simple) to another multi listbox?

the code I found on msdn only seems to support single column copies, i
need to copy 3 colums per selection

I was using a for each itm in somelist.itemsselected

and using the rowsource property , but this only gives me the first column

The source listbox is a lookup in a table and the destination listbox is
unbound as I will insert these values programatically.

Any help welcome

--
Bas Cost Budde
Holland