Printing current record

  • Thread starter Thread starter Greg
  • Start date Start date
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
 
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
 
Back
Top