If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Enter Parameter Value"
[Using Access 2007]
I've changed two fields in a table and subsequently deleted those original items from the corresponding form and have tried to insert the newly updated fields. Now, I am receiving "Enter Parameter Value" when I try to open the form. Also, when I try to insert the updated fields into the form, in the "Fields available for this view," the fields I deleted are shown in the list at the bottom and slightly indented to the left. I've also deleted two queries that I had started that I thought might be interfering and generating the "parameter" message. Any idea why: 1) I'm getting the parameter message and 2) Why those deleted fields are showing in the field list when I'm in the form? |
#2
|
|||
|
|||
"Enter Parameter Value"
One thing I can tell you from my experience. When you are getting the "enter
parameter value" it is because that value is not there. How did you re-insert the new fields? Did you use an update query, make-table query, append query or what? If you use an update query it won't delete the old records. Also make sure that you did not change the primary key or any relationships, as that could cause the problem. "ESheehan" wrote: [Using Access 2007] I've changed two fields in a table and subsequently deleted those original items from the corresponding form and have tried to insert the newly updated fields. Now, I am receiving "Enter Parameter Value" when I try to open the form. Also, when I try to insert the updated fields into the form, in the "Fields available for this view," the fields I deleted are shown in the list at the bottom and slightly indented to the left. I've also deleted two queries that I had started that I thought might be interfering and generating the "parameter" message. Any idea why: 1) I'm getting the parameter message and 2) Why those deleted fields are showing in the field list when I'm in the form? |
#3
|
|||
|
|||
"Enter Parameter Value"
You've deleted the fields from the form, but I suspect you haven't deleted
the fields from the query that your form is based on. Queries are the only objects in Access that prompt for parameters. You need to go into the query itself and delete them, then the query will stop prompting for them. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200803/1 |
#4
|
|||
|
|||
"Enter Parameter Value"
"but I suspect you haven't deleted the fields from the query that your form
is based on" Caveat: I'm a novice user but here's my confusion -- At this point, don't I just have a table and my form? I haven't set up any queries that run off the variables in this table. When you say "the query the form is based on" does that mean Access is running a query behind this form? As to my method of updating the form, I just opened the form in "Design View" and deleted the old fields and inserted the new ones. Is that too simplistic? "Linq Adams via AccessMonster.com" wrote: You've deleted the fields from the form, but I suspect you haven't deleted the fields from the query that your form is based on. Queries are the only objects in Access that prompt for parameters. You need to go into the query itself and delete them, then the query will stop prompting for them. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200803/1 |
Thread Tools | |
Display Modes | |
|
|