How to have report open to last page

[home70]

I have a report that opens with a button on a form and I'd like to have the report open to the last page. I tried using sendkeys and it works when I
manually open the report from Reports on the msaccess screen, but when
I use the button on the form the report opens to the first page. It
looks like the problem there is that the sendkeys command is processed
before the report opens, so the sendkeys command is focused on the form
and not on the report so the report just opens to the first page.
Anyone know a solution for this?
Thanks.

 

[home70]

I have found that after I open the report
with the form's button I can press the End key on my keyboard and
nothing happens. If I then use the mouse to click the next page or
last page button then the End key does work after that.
Any ideas?

 

[Rickster57]

printing last page

http://www.thescripts.com/forum/thread191653.html


See if this helps

 

[home70]

Thanks for the suggestion. I should've included that I preview the report more than I actually print it out.