Go to last page of report using Macro

[frontside]

I need to open a report using a macro and then go to that reports last page (I´m exporting a value from that page to another report) this report will be hidden during the whole time.


Does anyone has any good ideas?




I know you could go to a certain page of the report but not the last.

 

[DrSimon]

I was also trying to do something like this using VBA but couldn't work out how to do it. I'm interested that you say that you could use a macro to go to a certain page of a report - how? I thought GotoPage only works on a active form.

Simon Rouse

 

[frontside]

Since there was already a macro opening the report I thought it would be good to continue with the macro solution, I couldnt solve the problem the way I wanted to so I had to do a little walk around.

Since I wanted to export a value on the last page from one report to another I just made a copy of the first report. Then made everything hidden exept for the Report foot(where my value was)! that way it only shows one page every time, now it was no problem exporting the value to the other report.

Probably doesn`t make any sence but it did the job