Ca a collection be a rowsource for a report?

[adolph]

I generate a collection of errors from a procedure. I then show these
errors in a msgbox buy looping thru the collection and adding them to
a string called sMsg. in the msgbox, I ask the user if they would
like to print these errors. If they say yes, what is a way of
printing this list to the default printer, or better yet, create a
report that can be called with the collection as the record source.

Thanks in advance,
Adolph

[Tom van Stiphout]

Re: Ca a collection be a rowsource for a report?

On Mon, 11 Aug 2008 13:11:24 -0700 (PDT), adolph
<adolph@program consultants.com wrote:

No, but I'm pretty sure that rather than using a collection you could
use an ADO Recordset. You can create one out of thin air, add a few
fields to it, add your rows to it, and use that recordset as the
RecordSource for a report.

-Tom.
Microsoft Access MVP

>I generate a collection of errors from a procedure. I then show these
>errors in a msgbox buy looping thru the collection and adding them to
>a string called sMsg. in the msgbox, I ask the user if they would
>like to print these errors. If they say yes, what is a way of
>printing this list to the default printer, or better yet, create a
>report that can be called with the collection as the record source.
>
>Thanks in advance,
>Adolph