form won't let me delete field

[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?

 

[gls858]

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?

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

 

[John W. Vinson]

Help, I deleted a field in my form,

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.

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?

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!

 

[Helen]

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.