Repot Recordsource same as Form Recordsource

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
 
6

'69 Camaro

Hi, Alex.
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?
Click to expand...

No. The report's recordsource is defined by a dataset that must be
retreived from the tables when the report opens, even if this same dataset
has already been retrieved by another database object (i.e., the form) at an
earlier time.

There are ways to improve performance, though, such as by tuning the
database, tuning the query, upgrading the server hardware, upgrading the
network hardware, and removing network bottlenecks and unnecessary network
traffic.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top