Step-by-step solution to the "Enter Parameter Value" dialog

Question

Hi guys, I'm facing the "Enter Parameter Value" problem. Upon opening almost every object (tables, queries, forms and reports) I am faced with the "Enter Parameter Value" dialog box. It asks for the parameter value of several fields each time.

I've researched and found many complex answers, not in plain English, so they're pretty hard to understand for someone like me. Although I have picked up a few things like 'make sure there are no special characters or spaces in the names of any fields', which in my case there aren't, and 'Enter Parameter value appears when you have renamed and deleted fields'. Yes I have renamed and deleted several fields, but that still doesn't answer my question of how to fix this problem.

I know on AutoCAD there is a 'purge' function for this problem, and it removes any unreferenced objects in your drawing from it's database. Is there a similar command on Access or any other relatively simple solution to the 'Enter Parameter Value' problem?

Thanks

Answer 1

Ok, I've been going through the query builders of every object in Access and have been finding many fields with names starting with "(Expr," and am guessing these are my now deleted/renamed fields. So I have deleted these fields in the query builders and the problem seems to have disappeared. Thanks everyone for your help.

Answer 2

Do you have a database split into backend and frontend? It could be that the frontend and backend need to be relinked again. You can use the Linked table manager in Database Tools tab to do that.

---

Jeanette Cunningham MVP(Access) Pakenham, Victoria Australia

Answer 3

Solution suggestion for error happen for - direct use table to create form, and delete field in table will cause 'Enter Parameter Value'.

The the particular field, you can not delete  the 'field' in the Form field list as well.

Solution:

1. Open the form in Design View,2. Left click on the form but out side (under) detail, it might be grey color area.
2. Open Property Sheet, you will see “Record source” with "SELECT tbl....", open that and delete the field with "Expr" field.

(Please noted when you left click inside Detail and outside, the Property Sheet detail are different).

Answer 4

Download the free VTOOLS program and use the Total Deep Search.  You can then put in the exact parameter that it is asking for and it will give you a list of where that is used.  You can then go there to fix it to be the correct name, etc.

http://www.skrol29.com/dev/en_vtools.htm

---

Bob Larson Former Access MVP (2008-2010)

Ok, I have downloaded VTOOLS and opened the Total deep search. I then put in the parameter it wanted the value of, and it gave me a list of where it was, in this case it was in 153 locations. I then had no idea what to do, but I tried replacing the parameter with my new one - Passenger ID to PassengerID. While it removed the enter parameter value problem for Passenger ID, it then emptied my reports and forms making them seemingly unlinked and unusable. Then Access wanted me to enter parameter value for every single field. Please give me some advice on where to go next.

Answer 5

Download the free VTOOLS program and use the Total Deep Search.  You can then put in the exact parameter that it is asking for and it will give you a list of where that is used.  You can then go there to fix it to be the correct name, etc.

http://www.skrol29.com/dev/en_vtools.htm

---

Bob Larson Former Access MVP (2008-2010)