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

This article was previously published under Q98801
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY
This article shows you how to select a single record on a form and to printit in a report.
MORE INFORMATION
The following procedure prints only the record that you select from theCustomers form in the sample database Northwind.mdb (or Nwind.mdb inearlier versions).
  1. Create a report based on the Customers table and name it rptPrintRecord.
  2. 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]					
  3. 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					
  4. 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.
one
Properties

Article ID: 98801 - Last Review: 12/04/2015 09:27:28 - Revision: 2.1

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

  • kbnosurvey kbarchive kbfaq kbhowto KB98801
Feedback