Go to page in Report

[Miras]

Hi, I want to open report in preview mode and jump directly onto page with (for example) number 3. I'm opening it by clicking command button. Is it posible to go to some page by using vba or macro?

 

[idmcd]

This solution works, though it isn't very pretty...

Open your report using VB code, then use SENDKEYS to move about the report:

For example:

To go to page 3:
DoCmd.OpenReport "rptmEstimate", acViewPreview
SendKeys "{PgDn}{PgDn}", True

To go to the end of the report:
DoCmd.OpenReport "rptmEstimate", acViewPreview
SendKeys "{End}", True