Printing the current page being used

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

Guest

I am writing a database that transmits information to a report for leases, I
would like to print only the current page (in the form) that I am using from
the report, but everytime I click the "print report" button, the entire
report (every page in it) prints out. what settings do I use in the macro
for the report to ensure I am only printing the pages that I want?

Paul M
 
Paul said:
I am writing a database that transmits information to a report for leases, I
would like to print only the current page (in the form) that I am using from
the report, but everytime I click the "print report" button, the entire
report (every page in it) prints out. what settings do I use in the macro
for the report to ensure I am only printing the pages that I want?
Click to expand...


Modify your macro to use the OpenReport action's
WhereCondition argument with a reference to the record's
primary key.
 
Use the Where Condition arguement of the OpenReport method. You can do that
in the Click Event of the print report button before you open the report.
If you look in the VB Editor Help for OpenReport, you will find an example
of how it works.
 
ok, I've located the "where condition" in the macro, but I am still unclear
as to what I am supposed to do. I am not a VB guru so it is still greek to
me, if I could have someone walk me through this I could finish my project.

Paul M
 
Back
Top