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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Db Requesting Deleted Field Values

Status
Not open for further replies.

krispi

MIS
May 16, 2002
281
GB
I have a very simple DB - one table, one form, one subform. I recently deleted 2 fields from the table, and replaced them with 2 others (there was no data in there).

Now, when I open the DB, pop-up boxes appear asking for the parameter values for the deleted fields.

I am running an Autoexec macro to open the form. If I disable this macro the parameters are requested when I try tp open the main form, which is not unbound, as are all the fileds in the form - it is used for entering search criteria.

Any ideas why the parameter values are being requested - the fields no longer appear in any table, form or query in the DB - more importantly, any idea how to stop it from happening?

Any help gratefully appreciated
 
You might have some parameter settings still remaining in a query (check the Parameters option on the Query menu)or you might have sort/grouping rules set up on the old fields.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top