Results 1 to 3 of 3
  1. #1
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171

    Parameter Value for Deleted Field?

    I had added a field to a report. Later, I realized I did not need the field and removed it from the table and from the report and form. Now, when I go to run the report or open the form I am asked to "Enter Parameter Field" for that deleted field. I can't understand why it is asking me to enter parameters for a field that has been deleted from the table and form templates. Would it be that there is a query associated with the report that still has that field?

    Thanks in advance.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,412
    have you included it in your sorting or grouping properties?

  3. #3
    PATRICKPBME is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    171
    Looks like I figured it out. In a nutshell I learned that removing a field from a form, report and table does not remove it from any underlying query. Once I located the query and removed the field from there I was back to normal. I tracked the error by going to design view in the report and for and checking the record source in the property sheet pane.

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

Similar Threads

  1. Deleted records not actually deleted
    By soco3594 in forum Forms
    Replies: 6
    Last Post: 11-17-2015, 07:18 PM
  2. Replies: 1
    Last Post: 01-14-2015, 10:36 AM
  3. Using IN with a parameter and field
    By vclink in forum Queries
    Replies: 2
    Last Post: 04-01-2014, 10:51 AM
  4. Replies: 6
    Last Post: 02-25-2013, 07:51 PM
  5. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM

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