Regarding setting a Report's recordset

  • Thread starter Thread starter Sophie
  • Start date Start date
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
 
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
'====================================================
 
Back
Top