access reports design view when trying to print

[Stuart]

I have written a macro which will open a report and print the last record but
the macro fails because it is saying the report is in design view when it is
not.
If I run the macro first line "open report" it works fine, its just the "go
to record" which gives the problem.

 

[Duane Hookom]

You can't "go to record" in a report. You can open a report with the record
source of the report filtered to a specific record or records. I believe
Stephen Lebans has code at www.lebans.com for displaying a particular page
of the report.

 

[Stuart]

Thanks for the help.

You can't "go to record" in a report. You can open a report with the record
source of the report filtered to a specific record or records. I believe
Stephen Lebans has code at www.lebans.com for displaying a particular page
of the report.