Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Enter Parameter Value" on non-existent field

Status
Not open for further replies.

JFoushee

Programmer
Oct 23, 2000
200
US
Hello.

After deleting a field from an Access table, whenever I open the form, it asks about the value of that old field.

The field is not on the form; I do not know where it is coming from. None of the SQL on the form contains this field, none of the subforms mentions this field.

How can I get Access to quit asking for the value?
 
I run into this on several occassion and it can be really frustrating, however I always found that I overlooked something. The missing variable has to be somewhere in your form or attached queries. You can use the documenter in Access (available from Tools, Analyze, Documenter) to run detailed reports on the form, subform and queries then do a search for the variable. Make sure you go into 'Options' in the Documenter window and check 'Properties', 'Code', and 'Names and Properities'. You may have to export the documentation to Word to do the find.
 
The 'missing' parameter is often listed in the RecordSource PARAMETERS or in the Sortingand Grouping Property of hte report itself.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top