Limiting Report Records

  • Thread starter Thread starter George B.
  • Start date Start date
G

George B.

I have a library catalog form with a print report
button. However, I want the catalog report to only print
the current record onscreen when the button is clicked.
I've looked at the CurrentRecord Property, OpenArgs, etc.
and it confuses me. Any help will be greatly
appreciated. Thanks! George
 
-----Original Message-----
I have a library catalog form with a print report
button. However, I want the catalog report to only print
the current record onscreen when the button is clicked.
I've looked at the CurrentRecord Property, OpenArgs, etc.
and it confuses me. Any help will be greatly
appreciated. Thanks! George
.
Click to expand...
Hi George,
ensure that each record has a unique primary key or id.
For example BookID.
the code to print the current book displayed on the form
is:

docmd.openreport "rptReportName",acPreview,,"[BookID]=" &
BookID

BookID does not have to be a field on the form, so long as
this field is in the form record source.

Luck
Jonathan
 
Back
Top