Putting data from array into a text box

[robinsql]

Hi all,
How do I get the data from an array, into a text box on a report?
I have the three following arrays populated from a list view...

g_asPupilNum(j) = lvPupils.ListItems(i).Text
g_asNames(j) = lvPupils.ListItems(i).SubItems(1)
g_asClassName(j) = lvPupils.ListItems(i).SubItems(2)

How can I get the first text box on my report to display the first item from my array?

Which property should I use where I have placed an X in the following line of code?

objAccess.Reports(0).Controls!txtClass.X = g_asClassName(j)

Or is this the wrong way entirely?

Any help very gratefully received.

 

[Ecniv]

Arrays to reports?

Difficult, probably easier to create a temp report table, drop the arrays info in as you require and run the report.


Vince

 

[robinsql]

Yes, I was thining of a temp table, but is there even any way I can access what comes out in the text box without setting a ControlSource?