Results 1 to 6 of 6
  1. #1
    shelleyl868 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2018
    Posts
    3

    Report is requesting parameter that I want to delete


    I've copied a report and linked it to a new query. The report has some fields that are not included in the new query, so I've deleted those fields from the report--or I believe I have. However, every time I open the report, it wants a parameter entry for one of the fields. I've searched everything I can think of to figure out where this field or a reference to it still resides in the report but can't find it. How can I determine why the report still wants data for this field?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    I suspect you might have deleted one too many.
    Run the query. If that does not ask for the parameter, then it is in the report, or any function the report uses.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Also make sure it's not in Group & Sort.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    or in filter or order by in the report properties

  5. #5
    shelleyl868 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2018
    Posts
    3
    That's where it was! I can't believe I didn't look there. Thank you so much - I was getting ready to re-create the report and you saved me a couple of hours.


    Quote Originally Posted by pbaldy View Post
    Also make sure it's not in Group & Sort.

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 06-15-2020, 02:18 PM
  2. Replies: 4
    Last Post: 02-13-2018, 09:21 PM
  3. requesting help for database design
    By Kaytremain in forum Database Design
    Replies: 2
    Last Post: 10-25-2011, 05:00 PM
  4. Requesting Materials Report Assistance
    By pkott in forum Reports
    Replies: 2
    Last Post: 10-21-2010, 08:49 AM
  5. Form requesting to save changes
    By stevo2820 in forum Forms
    Replies: 0
    Last Post: 07-30-2007, 07:41 AM

Tags for this Thread

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