Listbox rowsource.. Pl help

[gdanalakshmi]

I have a listbox that I fill with the result of a crosstab query.
Since I have to add up the columns of the listbox columns I added code in VBA and stored the result in dynamic array and created another listbox below the first one. For the second listbox, how do I feed the dynamic array input.

Since My crosstab produces varying number of columns, I need to have dynamic array to totalup.

 

[PaddyIrishMan]

Just an idea but...
Maybe you could use the 'Join' Function on the array & populate the rowsource of the ListBox as if it were a value list.

I.e. MyStringVar = Join(MyArrayHere),";"

Will produce a single string delimiting all of the array elements by ;

This could then be passed to the List as a rowsource.

HTH,
Patrick