Recordset to Report

[Willam Roberts]

When if do my SQL in code to create a recordset , I have found I cannot
assign the recordset to a report. Is there a way to assign a recordset to a
report? Are temp tables the best route?

Thanks
William Roberts

 

[Armen Stein]

When if do my SQL in code to create a recordset , I have found I cannot
assign the recordset to a report. Is there a way to assign a recordset to a
report? Are temp tables the best route?

Thanks
William Roberts

Hi William,

If I understand what you are trying to do:

To create a certain SQL statement in code, then run a report based on
it, just create (or alter) the SQL statement during the Open event of
your report, and set Me.Recordsource to it. When the report continues
to open, it will use the new Recordsource.

Hope this helps,