Printing a single Record in a Report

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

Guest

I want to place a button on my form so that it will just print a report. I
only want it to print the current record. Not all of them. How do I go about
this?

Thanks in advance.
Travis
 
The following code should do the trick


me.Refresh ' write data to disk so
' reprot can see any
'changes

docmd.openreport "myreport",,,"id = " & me!id

The above will print the current record you are viewing...
 
You must log in or register to reply here.

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

Preview/Print Report 3
Button on form to print report for current record 4
Printing Report for one a single record - Several problems 5
printing 1 sheet of report 1
Get current record only to show on report 3
Printing a report 2
Copy current record to report form 2
Printing one report 4

Back
Top