Problem with Reports recordsource= Forms recordsource

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I want to print a report from a form.
Report and form have same quite complex recordsource.
With Reports!Myreport.recordsource= Forms!
MyForm.recordsource set of records is recalculated again
before printing.

Is there a way to avoid this?

Thank you in advance

Alex
 
Can you state what you mean by "recalculated again"? What are you
calculating and where?
 
In this mask I want to list records that not fulfill many
validation rules in a given period. Recordsource-Sql
statement includes many custom functions and it takes
maybe one ore two minutes to have recordset calculated
and records listed in form.
The problem is that if print these records in a report
using Reports!Myreport.recordsource= Forms!
MyForm.recordsource recordset is recalculated again
(again one or two minutes) before report opens.

Is there another way to pass records to a report ?


I hope you can understand what I mean. I write from
Italy, sorry for my English.

Thank you
Alex
 
In this mask I want to list records that not fulfill many
validation rules in a given period. Recordsource-Sql
statement includes many custom functions and it takes
maybe one ore two minutes to have recordset calculated
and records listed in form.
The problem is that if print these records in a report
using Reports!Myreport.recordsource= Forms!
MyForm.recordsource set of records is recalculated again
(again one or two minutes) before report opens.

Is there another way to pass records to a report ?


I hope you can understand what I mean. I write from
Italy, sorry for my English.

Thank you
Alex
 
I would use code to create a temporary table. Then use the table as the
record source for your form and report. I doubt there is any method of not
having to "requery" the record set.
 
Thank you

ALex
-----Original Message-----
I would use code to create a temporary table. Then use the table as the
record source for your form and report. I doubt there is any method of not
having to "requery" the record set.

--
Duane Hookom
MS Access MVP





.
Click to expand...
 
Back
Top