print the form displayed to a Single report

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

Guest

I need to print the current form data to a singel report. when I print a
report now I get all the reports for that form
 
Larry,
In your report, you need to filter the results so it only shows the one
record you want.
Each record should have a unique identifier (key) field. (for ex.
[CustID]) Use that field on the form to filter your reports.

In the query behind the report, in the CustID column, put this criteria...
(use your own names)
=Forms!frmYourFormName!CustID
hth
Al Camp
 
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

Access Access Report Works on One Machine but not Another 3
Form, instead of Report, Prints ??? 0
Report Input Parameters 2
Print a report without displaying print preview 1
Print all Tabs of a Report Created from a Form 1
Print report from form doesn't show current data 4
create a blank report 3
Print report control button on form printing all records 1

Back
Top