access reports design view when trying to print

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Thanks for the help.

Duane Hookom said:
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.
Click to expand...
 
Back
Top