Command button to open specific report

[Guest]

I have a command button on a form that I want to open a report, however I
want a specific page on a report. For example, my form is in a list of
customers and I want to be able to bring up that customers details on the
form and then click the command button to bring up their page of the report.
At present I can get the command button to bring up all peoples details in
the report (i.e. 30 pages!) Can anyone help?

 

[Rick Brandt]

I have a command button on a form that I want to open a report,
however I want a specific page on a report. For example, my form is
in a list of customers and I want to be able to bring up that
customers details on the form and then click the command button to
bring up their page of the report. At present I can get the command
button to bring up all peoples details in the report (i.e. 30 pages!)
Can anyone help?

You don't open the report to a specific page. You filter the report so it only
contains the pages you want.

The OpenReport method has an optional WHERE argument that lets you apply a
filter to the report on the fly as it is opened. Just specify the customer you
want.