• Phantom parameter request


    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?

    Viewing 0 reply threads
    • #2396186

      You haven’t mentioned that you’ve checked queries. In design view click on the query design tab then on parameters on the RH end of the ribbon. See if something’s in there. This may not be the problem but I vaguely remember having a similar problem.

      Eliminate spare time: start programming PowerShell

      1 user thanked author for this post.
    Viewing 0 reply threads
    Reply To: Phantom parameter request

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: