Want report to show only current record selected

[wbilbro]

Right now, I have my button set up on the form to print 5 copies. However, I only want to print 5 copies of the current record that I am working on.

Can I add something to my OnActivate to make this work and have it show only the current record?

Thank you!

Chris

 

[wbilbro]

If it helps, this is what I have so far:


Private Sub Report_Activate()
Dim NumCopies As Integer
NumCopies = 5

DoCmd.OpenReport "BOL Greenville", acViewPreview
DoCmd.PrintOut acPrintAll, , , , NumCopies
DoCmd.Close acReport, "BOL Greenville"
End Sub