Print current record to report

G

Guest

I want to print the current record from a form through a report. I have made
a reprot and also made a button to print the report, but I dont know how to
do the coding behind the button to make it print the current record on the
form. I would really appreciate if someone could help me out. Thanks in
advance
 
A

Al Camp

Juniad,
Use a query as the RowSource for your report, based on the same table as
your form.
Your form should have a Key, unique value field for each record... like a
CustomerID.
In the query behind your report, in the example CustomerID field, use
this criteria... (use your own object names)
=Forms!frmYourFormName!CustomerID
Now, when the report runs, it will only return the record you are
currently viewing on the form.
 

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

Button on form to print report for current record 4
Print Current Record 3
Get current record only to show on report 3
Access Access Report Works on One Machine but not Another 3
printing 1 sheet of report 1
Print current record 19
Printing only the current record on a report 10
help understanding code for printing 8

Top