Retrieve ALL data during creation of report

[djjesp]

Hi,

I want to retrieve all data for all pages of a report(and its subreports) in one time. So no db-activity when navigating through the different pages of a report, it should already be in memory.
Does anyone know a property or some VB-code to get this done??

regards Jesp

 

[Trendsetter]

This will rely on the query you generate to drive the report and from there on you simply useoCmd.OpenReport "RepName"

Hope this helps

 

[djjesp]

I'm using DoCmd.OpenReport.
The problem is that the reports are partly based on temporary tables. Tables I populate when the user wants to view a report. When a second user, in the same moment, wants to view the same report, based on different selectioncriteria, I overwrite the data of the temporary tables with new data.
What happens is when the first user navigates to a page which was not yet formatted, he will see a pages based on selectioncriteria choosen by the second user.
I think I can overcome this problem by formatting all the pages of a report during creation time of that report. What I want to know is, is there a property or method to do so.

Regards Jesp