Calculate time needed to generate report

[camilovic]

How I can calculate time (for ex. in mseconds) needed to generate report… from OnClick button event up to finish generate the report?
So, I’d like to compare which report is open faster. Those two reports are similarly. Displayed the same value. Difference is only in record source and criteria.
Thanks

 

[llkhoutx]

Save the time with the Now function before and after to open your report, eg.

dim dtStart as date
dim dtStop as date

dtStart = Now()
docmd.openreport "YourReportName"
dtStop = Now()

msgbox "Time to open: " & dtStop-dtStart