Printing a report for a single ID

[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.

 

[Duane Hookom]

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.