Subreport not showing data

[bbulla]

Hi,

I have a main report that is working fine. Once I add a subreport, link the two using the RECORDNUM in each, and then run the main report, I get prompted to enter a 'missing parameter' called 'tblWinterNightPatrol' .... which is the tablename of a table in the main report.

I don't get what is going on. Separately, both the main report and the subreport work as desired, but once I put them together strange things start to happen.

Any idea what I am doing wrong?

Thanks!

 

[vbaInet]

Upload the reports and I'll tell you where it is.

 

[bbulla]

OK,

I've attached my db to this post.

The report with the issue is rptWinterNightPatrol (access it through the Reports, not the form that pops up on start up).

Other than some formatting, the report comes up as I want it, but I want to get rid of the 'Missing Parameters' dialog box.

 

[vbaInet]

See attached, Road Patrol Master

 

[bbulla]

Awesome. Thanks for your help. I guess having that extra RECORDNUM in the query made the difference. Why does it matter though?

 

[vbaInet]

It shouldn't matter but you have many fields in that query so it probably just got confused. Or your db might have been corrupt.