Printing a report for a single ID

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

Hi there

Currently when I print my report, I see all the records in the database.

I would like to have only the reports for a single ID.

In my report, I can't find out where to put the query or the Master Link or
Child Link.

Any advice is greatly appreciated.
 
There are several ways to accomplish this. One method is to base the report
on a query that has your control on your form as the criteria. Under the
[Single ID] field you would enter something like:
Forms!frmYourFormName!txtSingleID

I prefer to use the Command Button wizard to create a button that opens the
report. I then modify the code so it conforms to the method described at
http://www.mvps.org/access/reports/rpt0002.htm.
 

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

Reports that sift records from different tables 0
Filtering subreports on main report 0
Multiple Records in One Report 1
chart child master link field 10
Printing Data Horizontally 1
Apply filter for Printing 1
Variable number of entries per field in contact report 1
Chart not working in report - Help requested 5

Back
Top