Go To A Report Page 1

[vbcnew55]

Hi,

Can someone help by telling me what the code is to move to a particular page number on an Access Report?

Using code, I have variables that capture the start page of each sub report. Now what I want to do is add functionality to go directly to that page number within the report.

There's a gotoPage method for Forms, but nothing for Reports.

Can someone help direct me to a reference to create this functionality?

Thanks.

 

[orna]

DoCmd.OpenReport ReportName, acPreview
Dim i, j As Byte

i = YourPageNumber
SendKeys "{F5}{Delete}"
For j = 1 To i
SendKeys i & "{ENTER}"
Next j

 

[orna]

shorter

DoCmd.OpenReport ReportName, acPreview
Dim i As Byte

i = YourPageNumber
SendKeys "{F5}{Delete}"
SendKeys i & "{ENTER}"

 

[lameid]

orna,

You must have an excellent resource for hotkeys.

Would you mind posting it?

I had no idea about F5.