Problem Deleting a Field - wants parameter for missing field...???

[Guest]

We have a simple relational database with two tables and one relationship.
Their are fields in one of the tables that are no longer used by any report
or form. When we delete a field and then open a form, access prompts ust to
"Enter Parameter Value" for the deleted field. " Why? How do we get around
this? What do we have to do to delete the unused fields?

 

[John Vinson]

We have a simple relational database with two tables and one relationship.
Their are fields in one of the tables that are no longer used by any report
or form. When we delete a field and then open a form, access prompts ust to
"Enter Parameter Value" for the deleted field. " Why? How do we get around
this? What do we have to do to delete the unused fields?

They can be several places. Check the Form's Recordsource property;
click the ... icon by it to open the recordsource query. If the
unwanted field is there, delete it. Also while you're there, use the
View menu to view the query's Parameters - remove the field from the
paramters list if it's there.

Also, for Reports, check the report's Sorting and Grouping property.
Unwanted fields often lurk there. <g> For either Forms or Reports,
check the Filter property as well.


John W. Vinson[MVP]

 

[Guest]

John,
Thanks. Apparently I don't know enough to follow your instructions. I
got to properties by opening the form and choosing "Properties" on the View
menu. I could not find a "Record Source" property. I did find "Control
Source" property and the drop down list with it did indeed list the field I
had dropped. I could find no way to delete it (delete key, right click and
"cut", drag... all failed). I am using Access 2003.

I could find nothing labled "Query" associated with the "Control Source"
property.

I will continue to look for a way to follow your instructions, but I
think I need more help.
Harry

 

[Guest]

John,
On a second form I did find a property labeled "Record Source". I
selected that property and a list of associated values appeared. None of
them was a field. With that property selected I found "field list " on the
View menu and it listed those fields explicity used in that form, but not the
deleted field that causes the prompt.

I then went to each report and viewed their properties (design view/View
"properties), but did not see a "Sorting and Grouping" property, or anything
like it. (properties included "date grouping" and "Grp Keep Together".

I am continuing to study all the forms, reports and queries - examining
thier properties and anything I can see with the "View" menu, but I'm not
making any real progress.

Harry

 

[Guest]

For one of the forms I found the icon that opened the associated query. The
offending field was not listed. I also found "paramaeters" under the Query
menu, but there was nothing in the list that appeared.

I am planning to shrink the database down to a few records and put it on a
web site. Then you, or someone, could take a quick look .

Harry