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

[JessicaOhio]

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

 

[Joe4]

Welcome to the Board!

Are you sure that the Form is based directly on the table, and not on a query instead, that is based on that table? If you go to to the Properties of the Form and view the Record Source, it should show you what the Form is actually based on. If it is a query, go to that query and remove all remaining references to that field too.

 

[JessicaOhio]

[Are you sure that the Form is based directly on the table, and not on a query instead, that is based on that table? If you go to to the Properties of the Form and view the Record Source, it should show you what the Form is actually based on. If it is a query, go to that query and remove all remaining references to that field too.[/QUOTE]

Thanks for the suggestion! It does appear that the form is based on the table. Any other thoughts?

 

[Norie]

Are you, or were you, sorting on the problem field?

 

[JessicaOhio]

I've contacted IT here and they're stumped too...

 

[JessicaOhio]

Sorting...hmmm... I wasn't. I doubt my student was (given that we don't know what that means).

 

[Norie]

Might be worth starting over with a new form, you can copy controls from the original.

 

[JessicaOhio]

Yeah. I've given up & started over. Stinkin' Access wins again.

 

[NoSmoke]

Yeah. I've given up & started over. Stinkin' Access wins again.

Heh, as fellow newbie I feel your pain. Access is one of the quirkiest programs I've ever used

Did you try Compact and Repair? Exporting the form as a text file and re-importing it worked for me to cure a weird problem. Also, try recompiling any VB code you may have associated with it (which I gather is good policy in any case when any changes are made, to the VB code itself or not).

 

[JesseB]

Welcome to the Board!

Are you sure that the Form is based directly on the table, and not on a query instead, that is based on that table? If you go to to the Properties of the Form and view the Record Source, it should show you what the Form is actually based on. If it is a query, go to that query and remove all remaining references to that field too.

This worked for me...

It was based on the same table, but had the word "SELECT" in front of it (Meaning that it turned into a query reference when the field was deleted). Re-selected the table in the record source and it stopped looking for the deleted field.