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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print oreview multiple records 8
Is this possible from Print Preview? 1
Excel VBA - Problem with Closing Print Preview 0
Print Curent Record From Form on Report 5
Print Report Landscape 1
Trying to print current record 1
Print just the current record showing on the form 4
Printing a report with consecutive pages 1

Top