I’ve got a report in Access 2007, with a sub report inside of it. Both reports point to queries that take user input for a date range; they both say date between [start] and [stop]. User keys in dates, report populates.
I linked the sub-report to the main report on the Master and Child fields on the Employee field, as well as [start] and [stop]. And it works—it only prompts me once for the start and stop date, and the report runs accurately.
I did what, as far as I can tell, is the same exact thing in another database. Yet when this one runs it just keeps asking me for the start and stop date endlessly. I’m at a loss as to why. I know it’s the sub-report date fields that it’s prompting for endlessly, as I changed the name on the date fields so I could tell where it was coming from. I just can’t see any reason why.