Getting to last page in report (1 Viewer)

[sammy5358]

After inputting into a form and pressing a button, I have a macro running a query then
opening a report and printing it. I only want the last record (page) of the report to print, how do I do this ?

 

[rjohnstone1]

It depends on how you have your report set up
if you have 1 record on each page, you could
use the record count command and then the
doCmd.printout value of recordcount when the report opens.
If this does not help, please provide more info.