Results 1 to 4 of 4
  1. #1
    oiliboi is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    8

    "Enter Parameter Value" when trying to open form

    I am trying to open Contact List and Contact Details forms and it asks me to "Enter Parameter Value" with the name of a field that used to be in my database.
    I do not understand what this is. If I click "Cancel" when I try to open Contact List, it brings me back to Design View. If I type something random it shows me Form View.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    What that means is that field which is no longer in your database is still somewhere in your Form, and you need to find it and delete it.
    What is Record Source of your Form? If it is a Query, try opening the Query directly and see if you get the same prompt for parameter. If so, it is still in the query and needs to be deleted out of there.
    Otherwise, look for it in places on your Form like sorting, grouping, and calculated fields.

  3. #3
    oiliboi is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2017
    Posts
    8
    Quote Originally Posted by JoeM View Post
    What that means is that field which is no longer in your database is still somewhere in your Form, and you need to find it and delete it.
    What is Record Source of your Form? If it is a Query, try opening the Query directly and see if you get the same prompt for parameter. If so, it is still in the query and needs to be deleted out of there.
    Otherwise, look for it in places on your Form like sorting, grouping, and calculated fields.
    Yes, it has a query:
    Click image for larger version. 

Name:	query.JPG 
Views:	12 
Size:	17.6 KB 
ID:	31116

    Even if I remove the query from Row Source and make this field a text box, or delete the query, when I try to delete the Company field, it tells me "Deleting "Company" field requires Contact management database to delete one or more indexes". It seems it is still connected somehow. I think I might as well just keep the field and Unhide it if it's giving me so many issues!

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Even if I remove the query from Row Source and make this field a text box, or delete the query, when I try to delete the Company field, it tells me "Deleting "Company" field requires Contact management database to delete one or more indexes".
    That appears to be an entirely different issue than the one you first asked about:
    I am trying to open Contact List and Contact Details forms and it asks me to "Enter Parameter Value" with the name of a field that used to be in my database.

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

Similar Threads

  1. Replies: 5
    Last Post: 03-14-2017, 07:50 PM
  2. Replies: 2
    Last Post: 09-01-2016, 11:00 AM
  3. Replies: 5
    Last Post: 05-06-2016, 11:43 AM
  4. Replies: 2
    Last Post: 05-20-2015, 08:26 AM
  5. Replies: 8
    Last Post: 07-15-2014, 05:56 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