By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

How do I open a Report to a specific page?

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.