Regarding setting a Report's recordset

S

Sophie

hello

I have a form whose recordset comes from a fairly complicated SQL, includung
sub queries. This works well, but takes several seconds to generate the
form's recordset.

When the user clicks cmdPrint, a report opens. The Report gets its
recordset from the following line in its OnOpen event...

Me.RecordSource = Forms!frmTeamAwards_Flight.Form.RecordSource

My problem is that the report also takes several seconds to open because the
SQL is run again. Here's my question - since the form (still open) already
has calculated this recordset, is there a fast way to get it to the Report
without executing the SQL a second time?

hope this makes sense
Sophie
 
J

John Spencer

I know of no way to do this. It may be possible, but since no other
person has proposed a solution my guess is that no one has a solution.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a recordset for a report 1
Using a recordset as a reports data source 3
Setting recordset/recordsource runtime 2
subtotals/totals from SQL statement 4
assign record source 5
Basing a report on a filtered form 2
How to set RecordSource to ADO recordset 1
Newbie: Displaying a Count() of Filtered recordset 3

Top