Recordset to Report

  • Thread starter Thread starter Willam Roberts
  • Start date Start date
W

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
 
WilliamR104 said:
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
Click to expand...
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,
 
Back
Top