Limit Report Print Preview to One Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report but want it to print only the record that's selected by
the print preview button. Right now the report displays all records.

Here's some details.

The report queries data from 3 related tables:

tblProfiles
tblPKCGPhysicalAttributes
tblPKCGMaterialAttributes

tblProfiles is related to the other two with one-to-one relationships.

The Event Procedure for the print preview button is:

Private Sub cmdprvwpkcgrpt_Click()
On Error GoTo Err_cmdprvwpkcgrpt_Click

Dim stDocName As String

stDocName = "rptPKCorrugated"
DoCmd.OpenReport stDocName, acPreview

Exit_cmdprvwpkcgrpt_Click:
Exit Sub

Err_cmdprvwpkcgrpt_Click:
MsgBox Err.Description
Resume Exit_cmdprvwpkcgrpt_Click

End Sub

THANKS!!!
 
Back
Top