Open report with last page 2

[berg43]

I like to open a report with the last page instead of the first page.Can anybody help how to do this.Thanks

 

[Zion7]

Depending on how your recordset is sorted,
just use the Where argument, of the open Report Method

Docmd.OpenReport "rptReport",,,"pkID =" & DMax("pkiD","tblSales")

Docmd.OpenReport "rptReport",,,_
"txtDate=#" & DMax("txtDate","tblSales") & "#

 

[berg43]

Zion,

Thank you for your help,but this is not what I am looking for.Your solution shows only the last data in the report, but I am looking for an report with for example 6 pages to open with page 6 instead of page 1.

 

[StarPassing]

Check out: faq703-3270

 

[berg43]

Thanks Starpassing , works perfect !!