Results 1 to 3 of 3
  1. #1
    axg275 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    19

    Report Complaining after Query update

    Hey guys one more question.



    I updated the name of the field in a query. I updated the box in the report that references that feild in the report by going into properties-->data-->control source and selected the new field name.

    However when I want to look at the report I get an error to "Enter Parameter Value"

    I tried googling this issue but im probably not explaining google correct issue Im having so maybe one of you can help me out. i click ok and it works but its annoying.

    Thanks!

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,159
    Did you add any grouping or sorting to the report based on the same field.
    That may also need updating.

    Reports create their own hidden underlying queries based on the one you use, so it may need a careful look around to find the issue.
    Normally it's a typo somewhere.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    axg275 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2014
    Posts
    19
    yep your right i had a sorting for that field and i did not know i needed to update that too. Thank you very much for helping me out!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update coulmn in Query Based on Max Report Date
    By janmack79 in forum Queries
    Replies: 3
    Last Post: 12-30-2016, 03:27 PM
  2. update query results when report is made.
    By Homegrownandy in forum Queries
    Replies: 10
    Last Post: 10-28-2015, 07:44 AM
  3. Replies: 1
    Last Post: 01-15-2013, 10:36 AM
  4. Replies: 2
    Last Post: 01-12-2012, 03:58 PM
  5. Query to automatically update report
    By kathi2005 in forum Access
    Replies: 13
    Last Post: 10-31-2011, 05:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums