Subreport not displaying

[Coll]

I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.

Thanks.

[Allen Browne]

Sounds like the subreport is incorrectly linked to the main report.

Open the main report in design view.
Right-click the edge of the subreport control, and choose Properties.
Fix the Link Master Fields and Link Child Fields (on the Data tab of the
Properties box, while looking at the Properties of the subreport control.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Coll" <co*********@hotmail.comwrote in message
news:11**********************@q75g2000hsh.googlegr oups.com...

>I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.

Thanks.

[Coll]

On Aug 13, 9:18 am, "Allen Browne" <[e-mail]:

Sounds like the subreport is incorrectly linked to the main report.

Open the main report in design view.
Right-click the edge of the subreport control, and choose Properties.
Fix the Link Master Fields and Link Child Fields (on the Data tab of the
Properties box, while looking at the Properties of the subreport control.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org."Coll" <[e-mail] in message

news:11**********************@q75g2000hsh.googlegr oups.com...

I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.

Thanks.- Hide quoted text -

- Show quoted text -

I added the subreports up by dragging them into the main report. I
don't have anything in the link masterfields and link child fields for
any of the subreports. Not sure what should be there if anything.

[Allen Browne]

You want the subreport to show only the records that match the record in the
main report. Therefore there is a field in the main report that matches a
field in the subreport.

Set the Link Master Fields is the name of the field in the main report, and
Link Child Fields to the name of the matching field in the subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Coll" <co*********@hotmail.comwrote in message
news:11**********************@57g2000hsv.googlegro ups.com...

On Aug 13, 9:18 am, "Allen Browne" <[e-mail]:

>Sounds like the subreport is incorrectly linked to the main report.

Open the main report in design view.
Right-click the edge of the subreport control, and choose Properties.
Fix the Link Master Fields and Link Child Fields (on the Data tab of the
Properties box, while looking at the Properties of the subreport
control.)

"Coll" <[e-mail] in message

>>
news:11**********************@q75g2000hsh.googleg roups.com...

>I have a report that I run every quarter. When I opened it this
quarter, one of the subreports is not displaying. No error message -
just nothing displays where the subreport data should be. If you run
the subreport on its own, it displays fine. It just won't display on
the main report. I tried deleting and readding the subreport. No luck.
There are other subreports on the main one and they are acting fine.
Any ideas? (Using Access 2000). I think this happened to me in the
past in an unrelated database. Can't remember how I resolved it.

Thanks.- Hide quoted text -

- Show quoted text -

I added the subreports up by dragging them into the main report. I
don't have anything in the link masterfields and link child fields for
any of the subreports. Not sure what should be there if anything.