Updating a form if field has been removed so that I don't get a me

Hi

I have created a form. Due to modifications to the form, I no longer need a
field which I have included in the original form.

Before I deleted the field, I had made a back up of my database.

When I delete the field, let's call it "ProductCodeOld", whenever I open up
the database, I get a text box saying that the "ProductCodeOld" is not in the
form or words to that effect.

How do I remove a field from a form without this type of message appearing?

Thank you in advance.

Forest8 -

You may have code in the form that references the old field. Even if you
delete the field, it won't delete code that may reference the field. You can
go into the module for the form and search for the old fieldname. Then you
can comment out or delete any pieces of the code that are no longer needed.
Another place to check is in the properties for the form, something as simple
as a filter to the form that could have been based on the old field can cause
problems opening the form.

--
Daryl S


"forest8" wrote:

Hi

I have created a form. Due to modifications to the form, I no longer need a
field which I have included in the original form.

Before I deleted the field, I had made a back up of my database.

When I delete the field, let's call it "ProductCodeOld", whenever I open up
the database, I get a text box saying that the "ProductCodeOld" is not in the
form or words to that effect.

How do I remove a field from a form without this type of message appearing?

Thank you in advance.