form won't let me delete field

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

Help, I deleted a field in my form, closed it, then deleted that field from
the underlying table. But when I go back to that form a parameter box pops
up asking for a value for that non-existent field.
How do I remove fields no longer needed from tables & forms after forms have
been (manually, tediously) created?
 
Helen said:
Help, I deleted a field in my form, closed it, then deleted that field from
the underlying table. But when I go back to that form a parameter box pops
up asking for a value for that non-existent field.
How do I remove fields no longer needed from tables & forms after forms have
been (manually, tediously) created?
Click to expand...

Sounds like the form might actually be based on a query. In the design
mode of the form go to properties and check record source. if in fact it
is a query delete that field from the query.

gls858
 
Help, I deleted a field in my form,
Click to expand...

Well, no, you actually couldn't have. Forms don't have fields - they have
Controls. You can delete a field from a Table or from a Query; if you do so
you will then need to remove all references to the field - such as controls on
your form.
closed it, then deleted that field from
the underlying table. But when I go back to that form a parameter box pops
up asking for a value for that non-existent field.
Click to expand...

First check the form's Recordsource property. It's likely to be a query based
on your table; remove the field from the query. Click the ... icon by the
property to open a query design grid and if it's still got the defunct field,
remove it.

Then, check to see if you have that table field referenced in some other way:
might it be in the form's Filter, or its Order By, or in the control source of
some calculated control on the form?
How do I remove fields no longer needed from tables & forms after forms have
been (manually, tediously) created?
Click to expand...

Just track down *all* of the places that the field was mentioned and remove
them all. It can be tedious, especially with a complicated form!
 
Thanks to both responses. It was not part of a query but was related to
another table via a lookup. Which I guess is a type of query - I'll work
with that. Thank you.
 
Back
Top