How do I remove "enter perameter value" prompt in Access?

[Tzalkia]

I created a table and form in Access. I modified the table. Now when
selecting the Form view I always get a message "enter perameter value" for
the fields that were deleted. I have compacted and repaired but still get
the message. The deleted fields also still appear in the "add existing
fields" field list. How do I get rid of them?

 

[Arvin Meyer [MVP]]

I created a table and form in Access. I modified the table. Now when
selecting the Form view I always get a message "enter perameter value"
for
the fields that were deleted. I have compacted and repaired but still get
the message. The deleted fields also still appear in the "add existing
fields" field list. How do I get rid of them?

Delete the "fields" from the forms. What has happened is that the form is
still binding the controls to non-existent fields. Any additions or changes
can be done by adding the controls or changing the controlsource on the
form.

 

[Tzalkia]

Delete the "fields" from the forms. What has happened is that the form is
still binding the controls to non-existent fields. Any additions or changes
can be done by adding the controls or changing the controlsource on the
form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

How do I do that? (I would need a step-by-step-how-to.) The form does not show the fields so where do I delete from? The table does not show the fields either. Oh yeah, this is Access 2007 Thanks

 

[KARL DEWEY]

Open the form in design view, click on menu VIEW - Properties. Read what the
Record Source says. If the SELECT statement includes the fields then edit
them out.