How do I open a Report to a specific page?

[Mike Cox]

Hi. I added a button to a form so it opens up a report. The reason
for this is that I want to print the data in *that* specific form in a
specific formatted manner. Unfortunately, the report starts at page
1, instead of lets say record 1,500 which I want to open in the report
and print. I have to manually type the correct page number. How do I
set it so it opens the report and the report would be on page 1,500
AND it would only print page 1,500 and NOT all the records?

Thank you kindly in advance.

[fredg]

On 19 Aug 2004 13:35:39 -0700, Mike Cox wrote:

Hi. I added a button to a form so it opens up a report. The reason
for this is that I want to print the data in *that* specific form in a
specific formatted manner. Unfortunately, the report starts at page
1, instead of lets say record 1,500 which I want to open in the report
and print. I have to manually type the correct page number. How do I
set it so it opens the report and the report would be on page 1,500
AND it would only print page 1,500 and NOT all the records?

Thank you kindly in advance.

Every table should have it's own unique Prime Key field.
Assuming the Prime key field name is [RecordID] and it is a Number
datatype, and is displayed on the form, then code the command button's
click event:

DoCmd.OpenReport "ReportName", acViewPreview, , "[RecordID] = " &
[RecordID]

Only the record that matches the RecordID shown on the form will
appear in the report.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.