Retrieving values from a query and putting it into a collection

[Jen]

Hi,

I have a problem regarding retrieving a number of results from a query
(which is fine and working) and putting them in a collection within the code.
The problem I seem to be having is executing the query from the code and
putting it into a collection.

Any tips/advice much appreciated.

Thanks,
Jen

 

[solex]

Please post your code

 

[Marshall Barton]

I have a problem regarding retrieving a number of results from a query
(which is fine and working) and putting them in a collection within the code.
The problem I seem to be having is executing the query from the code and
putting it into a collection.

Seems pretty straight forward, just open a recordset on the
query and loop through the records appending the value to
the collection. But WHY?? A recordset is often easier to
work with than a collection.