Printing current record

G

Greg

I have a sub form with multiple records for each customer that i would
like to print only the current record being viewed.
what code do i need for the print button to print current record without
opening a print preview window?

Many thanks in advance
Greg
 
A

Al Camp

Greg,
Use the OpenReport Where argument to specify a filtering value. (You'll
need to have your print button on each record, so that when the botton is
clicked Acess will know which record is current)
Use the key field value for filtering... say ex. CustID...

DoCmd.OpenReport "YourReportName",,,"CustID = " & CustID
 
Top