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

ID: Q98801

The information in this article applies to:

SUMMARY

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

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).

  1. Create a report based on the Customers table and name it rptPrintRecord.


  2. Create the following macro and save it as mcrPrintRecord:

    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.


Additional query words: one 


Keywords          : FmsOthr 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: March 24, 1999