retrieve table contents from an array

[bonecone]

Is there a function like DLookup that can retrieve multiple rows into an array instead of just one field value from one record, or do I need to come up with a custom solution?

[ketbdnetbp]

bonecone - Personally, I haven't come across a function of that nature, so I think you'll have to find a custom solution. One way is to walk a recordset and populate an array based upon field values. Then, use the array data to perform some other task by referring to the individual elements of the array.

Hope this helps,

Jim