Subreports

[Renee]

I have a Report that contains two subreports on it. The main report and the
two subreports are based on three different tables. The main report's table
has a primary key called SWO ID and the two tables for the subreports have
this field in them as well to connect them to the main table. When I go to
open my report I have it filtered to enter the SWO ID # and it selects the
correct information for the main report but then both subreports bring up the
data from all SWO ID #'s. (eq. if I ask for SWO ID #9 it brings up the info
for SWO ID #8 as well in the subreports). Any idea why it does not filter
just the one SWO ID #?

 

[Duane Hookom]

You must set the Link Master/Child properties of the subreport controls to
the [SWO ID] field.

 

[Renee]

That worked great. Thank you!

You must set the Link Master/Child properties of the subreport controls to
the [SWO ID] field.

--
Duane Hookom
Microsoft Access MVP

I have a Report that contains two subreports on it. The main report and the
two subreports are based on three different tables. The main report's table
has a primary key called SWO ID and the two tables for the subreports have
this field in them as well to connect them to the main table. When I go to
open my report I have it filtered to enter the SWO ID # and it selects the
correct information for the main report but then both subreports bring up the
data from all SWO ID #'s. (eq. if I ask for SWO ID #9 it brings up the info
for SWO ID #8 as well in the subreports). Any idea why it does not filter
just the one SWO ID #?