I have a table [tbl_Quarterlies] that includes a date field [QreviewEndDate]. This field appears in queries built upon [tbl_Quarterlies] and in report [rpt_Quarterlies]. So far, so good. I made copies of several of these objects related to Quarterly data for the purpose of Annual Reviews (consisting of largely unrelated information albeit requiring similarly structured objects) and then modified objects/fields as needed to serve the new purpose.
When I run [rpt_AnnualReviews] I receive a prompt to enter a parameter value for [QreviewEndDate]. However, this field is nowhere to be found in the objects related to Annual Reviews. I have reviewed every control in the report; I have examined underlying data sources; I have searched for “[QreviewEndDate]” in the code. I have read Access’ Help on the topic “Why does Access want me to enter a parameter value?” without finding an answer. Is there something else I can do or does Access have a bug that might account for the persistent parameter request?
