News, tips, advice, support for Windows, Office, PCs & more
Home icon Home icon Home icon Email icon RSS icon

We're community supported and proud of it!

  • 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.

      Every day is the dawn of a new error

      1 user thanked author for this post.
      • #2396203

        I have checked all data sources, Qre viewEndDate was not found.

        • #2396209

          You said EndDate a few times, but the screenshot shows DateEnd.

          Windows 10 Pro version 21H2 build 19044.1387 + Microsoft 365 (group ASAP)

          1 user thanked author for this post.
          • #2396214

            My mistake, all of those instances should have read QreviewDateEnd

    Viewing 0 reply threads
    Reply To: Phantom parameter request

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