I have tried so hard to get that sort of thing to work - can't be done access
2K3 (not sure about 2K7).  I have created a number of accounts applications
for a group of companies - thier bank statements run into thousands of pages
and I tried to open a report (statement checker) at a certain page containing
that record I was on (on a form)

Can't be done (by me anyway)

The problems you will have is that if you filter your report to show only a
few (or one) record then you loose all the other information based on the
report in full (like totals in the footer, etc).  Of course you could
redesign your report to have the summeries in a sub report and possition this
in the header.  But even that is full of problems.

So - I don't think it can be done.

The only thing I came up with that does work is to filter the report to show
all records "before" the record you are looking for and then invert the sort
order (on click from the form).  This will keep the totals (up to your
record) in place - but still not ideal - but it means you can see the record
you want

***************************
Mind you - if anyone reading this has a method I would love to hear it
How to go to a certain page on a report the contains a certain record ( of
course the page size and number of records is a variable - due to printer
choice)