Deleting Field - then problem with form... ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have a simple Access DB with two tables and one relationship, three forms
and two reports. There are unused fields in one of the tables. After we
delete a field, running one of the forms prompts us for a parameter for that
deleted field. Why? How do we avoid this? I have searched properties &
parameters for forms, queries and reports and can find no reference to the
dropped field. I am probably not looking in the right place. I know very
little about Access.

If someone could e-mail me directly at (e-mail address removed) I would e-mail them a
512KB version of the DB (7 records in each table) showing the problem.
 
The form is referencing that field somehow.

Either there's still a text box (or other control) on the form that's bound
to the former field, or the recordsource for the form is a query that
includes the field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enter Parameter Value in Access Form 0
DELETE FROM a table WHERE... 1
Hyperlink Field Problems 2
Problem Deleting a Field - wants parameter for missing field...??? 4
Corrupt File, Help with Possible Solution 4
Deleted Field in table issue 3
Can't change field length, there no relationships??? 5
Error 3201 You can't add or change a record...when delete/deleting 2

Back
Top