print a single record in vba

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

Guest

I have tried to print a single record using vba but all it does is to print
all records pertaining to the database open at that time via a report.
There does not appear to be a single command that will print a single
record. I have tried using printout etc to no avail.
 
Hi,
you have to filter your report first - once you have primary key field - run
docmd.openreport with where condition "MyID=" & Forms!MyForm!MyID
 

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

Access 2010 Report Button 0
Printing Reports on single records upon request 2
Excel VBA - Problem with Closing Print Preview 0
A macro to do the open several reports to print 4
Programming Report to print only 1 page 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Create Table of Contents 2
Printing to PDF from VBA 4

Back
Top