JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
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
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.
[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?
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).
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.
