Enter Parameter Value

[dawnd3]

I am at my wits end. I have a form that has a query as it's data source. I changed the name of a field in one of the tables and now when I open the form I get the "enter parameter value" with the old field name. Well this field isn't even in the query or the form, just in the underlying table. I have checked all the properties of the form and the query and even the "parameters" of the query and cannot find reference to this field ANYWHERE. I even searched any underlying vba code. (and compacted and compiled)

It actually doesn't happen when I open the form, it happens after opening the form and scrolling up to see the records. This is a 2003 database that I open and edit in 2007.

Thanks for any ideas on how to fix this. And I have

Dawn

 

[dhookom]

I would check the ORDER BY and FILTER properties of the form. Then check every control source to see if the field is used in any expression. Then check every Row Source of all list and combo boxes. Then check every Row Source of all charts. Then check every Link Master/Link Child of every Subform and Chart.

Duane
Hook'D on Access
MS Access MVP

 

[dawnd3]

I think I did all that, but will go through it again thoroughly. Will let you know. Thanks!!