You are currently offline, waiting for your internet to reconnect

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

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

This article shows you how to select a single record on a form and to printit in a report.
The following procedure prints only the record that you select from theCustomers 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: 06/24/2004 18:14:00 - Revision: 2.0

  • Microsoft Access 2000 Standard Edition
  • kbhowto kbinfo KB209560