"Enter Parameter Value" for a field I've deleted! Help, please

JessicaOhio

New Member
Joined
Apr 26, 2013
Messages
5
I'm pretty much brand new at Access 2007. I have a student who has been helping me with data entry. We've done something to the form that we can't figure out and can't fix.

From what she remembers, she created a new field in the wrong table and then deleted it. She then created the same field in the right table and tried to put that field in a form. Now, when we open the form, access pops up a dialog box that says "Enter Parameter Value: Annual Review Data. Inauguration Committee" where "annual review data" is the table and "inauguration committee" is the field.

My first solution was to delete the field from the form and the table and redo it. But that didn't outsmart Access. We're still getting the dialog box. Perhaps I haven't /really/ deleted the field because it still shows up in the Field List in the From design view. But where is it hiding? I've been wrestling with this for hours and might just throw the computer out the window.

Any other solutions?? Any help would be GREATLY appreciated!!
-Jessica
 
I have the same issue EVERY TIME I delete a table field after I create a form. I found that the field is still in the Record Source for the form. When I delete the field, the problem goes away. This has been the same for a lot of years and updates to Access. It is clearly a bug because nowhere does MS tell you that this step is necessary. Like so many bugs, it is clear that MS has no intention of fixing it...ever.
 
Upvote 0

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
EVERY TIME I delete a table field after I create a form
Yes, that is a field.
the field is still in the Record Source for the form. When I delete the field, the problem goes away.
No,that is a control on the form. To call it a field is common but technically wrong.
To suggest that deleting a table field and leaving the control on the form and getting a parameter prompt when you open the form is a bug is, well, odd.
It's probably not covered by documentation because the notion that a control must be removed also, lest it be looking for its data, is common sense. If one forgets to do that, one gets the prompt as a reminder.
 
Upvote 0
So if you added a new field in a table, would you expect that to be added as a control on your form, and where? :(
 
Upvote 0

Forum statistics

Threads
1,224,872
Messages
6,181,499
Members
453,047
Latest member
charlie_odd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top