Originally Posted by
June7
The domain aggregate will include all records in the calc unless there is filter criteria included in its WHERE CONDITION argument.
Since you reference the table without filter, all records are counted. Consider:
=DCount("[PatchNo]", "[tblPatch]", "PP_ID='" & [Enter Patch Pack Number] & "'")
If you don't care about showing raw details on the report, an alternative could be to do individual aggregate queries for each 'many' table then join those queries to the parent table. Each aggregate query would require same filter criteria. This is where reference to input on a form is nice. One input instead of multiple popups.
Also, subreports is still an option to consider. Again, have the subreport RecordSource reference control on form for filter parameter.