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

Article translations Article translations
Article ID: 209560 - View products that this article applies to.
This article was previously published under Q209560
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Expand all | Collapse all


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


The following procedure prints only the record that you select from the Customers form in the sample database Northwind.mdb.

  1. Create a report based on the Customers table, and then name it rptPrintRecord.
  2. Open the Customers form in Design view. Add a command button to the form, and then set the following command button properties:
       Name: cmdPrintRecord
       Caption: Print Record
       OnClick: [Event Procedure]
  3. Set the OnClick property to the following event procedure:
    Private Sub cmdPrintRecord_Click()
       Dim strReportName As String
       Dim strCriteria As String
       strReportName = "rptPrintRecord"
       strCriteria = "[CustomerID]='" & Me![CustomerID] & "'"
       DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
    End Sub
  4. Open the form in Form view, and then click Print Record. Note that the report preview is limited to the current record from the Customer form.


Article ID: 209560 - Last Review: June 24, 2004 - Revision: 2.0
  • Microsoft Access 2000 Standard Edition
kbhowto kbinfo KB209560

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from