[AccessD] SubReport in an ADP

I know I have done this before, but at the moment I cannot find one of my
working examples.


I've created a report that may be one or more pages.
The report is bound to a stored procedure.

When prompted for the customer number (the sproc's only input parameter),
the report populates
as expected and displays page 1 of N on the bottom of the page footer.

The users need to print these reports in batches, so I thought I could drop
in the report as a subreport, linking a master & child field.

This doesn't seem to work for me.

The sub report exists in the parent report's detail section.

I've even created a field in the sub report and pointed it to the
master/parent report using "=Reports!Report2!CustNo"

Both reports display the CustNo fields correctly, but the data in the child
report(s) is not populating

I've searched and searched online, and tried the recommendations, but none
seem to work.

Some of the recommendations are:

1. Change the Child report's rowsource to be a View instead of a SPROC and
let the link fields handle the data. Nope.

2. Create a field in the Parent report. Name it the same as the sub
report's input parameter (without the @). Nope.

3. Populate a field on a hidden form in the OnCurrent/OnFormat event of the
parent report. Make the Input parameter of the sub report look at that
field. Nope.

Any ideas?

Both