Printing a report for a single ID

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.

--
Duane Hookom
MS Access MVP


"forest8" wrote in message
...
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.