Microsoft KB Archive/98801

= ACC: How to Print a Single Record from a Form in a Report =

Article ID: 98801

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q98801



Moderate: Requires basic macro, coding, and interoperability skills.



SUMMARY
This article shows you how to select a single record on a form and to print it in a report.



MORE INFORMATION
The following procedure prints only the record that you select from the Customers form in the sample database Northwind.mdb (or Nwind.mdb in earlier versions).  Create a report based on the Customers table and name it rptPrintRecord.  Create the following macro and save it as mcrPrintRecord:

NOTE: The expression in the OpenReport event is refering to the CustomerID field of the customer's form.

In Microsoft Access 97:         Macro Name       Action -        mcrPrintRecord   RunCommand OpenReport

mcrPrintRecord Actions --        RunCommand Command: Save Record

OpenReport Report Name: rptPrintRecord View: Print Preview Where Condition: [CustomerID]=Forms![Customers]![CustomerID] In Microsoft Access 7.0:         Macro Name       Action -        mcrPrintRecord   DoMenuItem OpenReport

mcrPrintRecord Actions --        DoMenuItem Menu Bar: Form Menu Name: Records Command: Save Record

OpenReport Report Name: rptPrintRecord View: Print Preview Where Condition: [CustomerID]=Forms![Customers]![CustomerID] In Microsoft Access 1.x and 2.0:         Macro Name       Action ---        mcrPrintRecord   DoMenuItem OpenReport

mcrPrintRecord Actions --        DoMenuItem Menu Bar: Form Menu Name: File Command: Save Record

OpenReport Report Name: rptPrintRecord View: Print Preview Where Condition: [CustomerID]=Forms![Customers]![CustomerID]   Open the Customers form in Design view. Add a command button to the form and set the following command button properties:

In Microsoft Access 2.0, 7.0, and 97:         Name: cmdPrintRecord Caption: Print Record OnClick: mcrPrintRecord In Microsoft Access 1.x:         ControlName: cmdPrintRecord Caption: Print Record OnPush: mcrPrintRecord  Open the form in Form view, and then click the Print Record button. Note that the report contains only the current record from the Customer form.</li></ol>

Additional query words: one

Keywords: kbfaq kbhowto KB98801

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.