Loading a Table to an Array

[maverick]

Hey everyone,

anyone know a quick way to load myArray() with the content of a table ?

The table has no key or IDs, it just holds Label Captions

tia

+--------------------------+
| "Hacker by Heart" |
| Yahoo! : saenzcorp |
+--------------------------+

 

[maverick]

ok I added prikey because they were getting out of order,

here is more info: I have a report that I would like to change the header via this table,

for example:
record 1 = Report Header
record 2 = Report Footer
etc...

But I need to create an expression that that can use the value of record 1 as the caption on a label in the report

any ideas...

tia


+--------------------------+
| "Hacker by Heart" |
| Yahoo! : saenzcorp |
+--------------------------+

 

[PHV]

In the Object browser (F2 when in VBE) do a search for DLookUp or GetRows and then feel free to play with the F1 key.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244