delay printing a report

[109bow]

I have a number of reports that have up to 36 text boxes on each, each text box uses the DLookUp function to find specific records. When I run a macro, using the Open Report function and have the view set to print, the report prints out before all the text boxes have been filled with the required data. Is there any way of adding a pause to the macro, to give time for the text boxes to be filled with their data before it prints.
As I said I am using the open report function, with the view set to print and then the close function.
I use this macro to automate the printing of 6 different reports and then close them all.
Thanks in advance:banghead::banghead:

 

[Ranman256]

You should NOT be using Dlookup on a report.
The query should provide everything on the report.

 

[JHB]

You could try by putting in a DoEvents in the report's OnOpen event or OnLoad event.