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.
Create a report based on the Customers table, and then name it rptPrintRecord.
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]
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
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.