Subreport only showing 8 results from query. 1

[metrodub]

Not sure how this happened...

I have a subreport that shows classes taught by a facilitator. The main report shows facilitator data such as address, phone, etc..

For some reason, the subreport is only showing 8 results no matter which facilitator is chosen. When I run the query on its own, the results are correct, but when the report runs there are only 8 results.

Any idea as to how or why this is happening?

Thanks

 

[lupins46]

You need to check the linkchild and linkmaster properties of the subreport.

 

[metrodub]

Both are set to PartnerID, but there isn't a distinction between the two. One PartnerID comes from the query used for the main report, the other comes from the query for the subreport. Should I change them?

 

[dhookom]

Is the subreport control set to Can Grow: Yes?
Having the same field name in the main report and subreport should not be an issue.

You mention "facilitator" in your first post and then mention "PartnerID" in your recent post. Are we supposed to understand a relationship?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[metrodub]

Sorry, facilitator and partner are the same person. I will look at the can grow setting.

 

[metrodub]

The can grow setting was set to yes, so it isn't that. The strange thing is that this worked yesterday.

 

[dhookom]

Is the section containing the subreport set to can grow?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[metrodub]

That did the trick. The detail section was not set to Can Grow.

Thanks for your help! Here's a star.