Subreports Not Opening

[Knicks]

Access 2002 Question

I have a report that has 2 subreports in the detail section. The initial container report has no data source and is triggered from a popup form that contains 2 fields to satisfy both underlying parameter queries in the subreports.

The odd thing is that the 1st subreport opens but the 2nd doesn't. If I just open the initial container report without utilizing the popup form, both open when I enter the parameters twice.

I have almost an exact replica of the same situation except I use a different field and it works fine, which makes me really wonder what the problem could be.

Any help would be appreciated.

 

[Knicks]

Well after 4 hours, I should have waited until 4 hours and 5 minutes before sending out an SOS.

I figured it out, the 2 sets of parameters were just ever so slightly different. I cut and paste from the one working and everything opened.

I have 2 huge data sets that can't be combined and using subreports to look at them together but separate was my route of making the best of a bad situation. They are linked tables with over 8 million records each, I thought there might be more to this prob than meets the eye,

Thanx if anyone started this. I love this forum!