Report access data once

[Abedecain]

Hi, does anyone know how to preload all the data from a query for a report and not access it again?



At the moment when I scroll it reloads all the data and is very slow as the query is rather complex.

If you could that would be great!

Lucas

[Abedecain]

Oh and print preview wouldn't be useful as I need the records to be interactive to load a form.

[A S MANN]

You can add a new field No_Of_Print ( No ,single,Default 0 ) in table which is source of that query. When the report is generated by clicking at form control through VBA update that field as 1.
Put a condition in control that If [No_Of_Print] = 1 Then close event without opening report
ElseIf [No_Of_Print] = 1 Then
OpenReport
That way you can open report only once