Article ID: 98801
Article Last Modified on 1/18/2007
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q98801
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
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).
- Create a report based on the Customers table and name it rptPrintRecord.
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]
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
- 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: kbfaq kbhowto KB98801