Deleted a field from form & table. "Enter parameter value" message

[River Rouge Library]

Hi, I deleted a field from a table, and then went to the form and deleted the
same field.

Now, whenever I open the form, it asks me to "enter parameter value" for the
deleted field. How do I make it stop doing this?

Or do I just need to delete the form and create it again?

Thanks in advance.

 

[Jeff Boyce]

Is the form based directly on the table, or on a query?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hi, I deleted a field from a table, and then went to the form and deleted the
same field.

Now, whenever I open the form, it asks me to "enter parameter value" for the
deleted field. How do I make it stop doing this?

Or do I just need to delete the form and create it again?

Thanks in advance.

Somewhere on that form, you're still referencing the field. The first places
I'd look:

- View the form's Properties. Find the Recordsource property on the Data tab,
click the ... icon by it, and open the query datasheet. If the deleted field
is still there, remove it from the query and accept Access' offer to save the
SQL when you close the query window.

- Check the form's Filter and OrderBy properties, and remove the field if it's
there.

If you still get the error, post back - there are some other places it could
be buried.

 

[Dirk Goldgar]

Hi, I deleted a field from a table, and then went to the form and deleted
the
same field.

Now, whenever I open the form, it asks me to "enter parameter value" for
the
deleted field. How do I make it stop doing this?

Or do I just need to delete the form and create it again?

Thanks in advance.

You also posted this question independently in a different newsgroup, where
you've received a couple of answers. It's better not to do that. It's
called "multiposting", and it's generally frowned on because others don't
know what answers have already been given, and so they duplicate the effort.
Also it's harder for you to keep track of the various replies, and it's
harder for later readers of the question, who may be looking for the same
answer, to learn what they need.

In most cases a single, well-chosen newsgroup will do. If your question
really is relevant to more than one newsgroup, the approved technique is to
"crosspost" it instead, by listing multiple newsgroups in the To: or
Newsgroups: line of a single message. If you do that, the message and any
replies will appear in all the listed newsgroups automatically, which is
beneficial to all concerned.