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

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