subreport works on its own but not in main report

[krc777]

I have a subreport that lists out all the data when it is run on its own.
When I include it in the main report it only displays part of the results.

 

[Banaticus]

It's probably limited in some way -- did you create the main and sub reports in the Form Wizard? When looking at the main form in design view, select the subform box then click Properties up on the toolbar and look at the "Link Child Fields" and "Link Master Fields" and see if they match up. We really need more information before we can help you, though. What are you trying to do? What do the different forms display?

 

[krc777]

The main and sub are both linked on PmtYr. That appears to be okay to me. Pmt Yr in both forms runs from 2004 to 2006. In the main form I just have titles and then two subforms the first with totals and the second showing the percent change. The first subform shows all data from 04 to 06. The seconds subform only shows 2004 and 05 data no 06. The 2nd subform when run on it's own shows all 04 to 06 data. The two subs aren't related in any way are they?
k

 

[krc777]

Found it! The first subreport didn't have any Link Child and Master set so I changed the 2nd sub to match and that worked. Now everything is displayed. Thanks.
k