Report to Array via VB need help!!

[TheGerman]

Hello,

I hope somone can help me solve this problem!

I need to fill an array with Data from a Report!


For i = 1 To Report_UpdateReport.Count

myarray(i) = ?

Next i

How do i fill the array with the information? People suggest me to use the
..EOF command but access dosn't seem to find that command.
I would highly appriciate it if you could help me fill this array. The
field in my report i want is called "parentid" and the reports anme is
UpdateReport

Thank you very much!

~Daniel

 

[Duane Hookom]

Your ReportName.Count will return the number of controls on the report.

What information from the report do you want to store in the array? A list
of control names or values from fields in the record source?

Why would you want to use a report to fill an array? I can't imagine how
this would be used.

 

[TheGerman]

I want the "parentid" field which contains serveral codes such as

"00125" and "01541" and "c59d120"

I want to put them all in an Array so i can reuse those id's to call other
reports and such

 

[Duane Hookom]

I would do everything possible to avoid using a report to do anything but
print formatted records.