Deleting Fields from a form



I deleted a few fields in a form I created. I also deleted them from the
table I created the form from. When I open the form it asks me to "Enter
Parameter Value" for each of the fields I deleted. How do I fix this?


It sounds like the form's recordsource is actually a query build on the table
and when you deleted the fields from the table you didn't modify the query.

John W. Vinson

None of the fields i deleted are part of any query

Open the Form in design view, and view its Properties. What is the
Recordsource property? Access has probably created a "hidden" query for you.
If it's a query name or a SQL string, click the ... icon by it to open it in
query design view and delete the uneeded fields.

John W. Vinson [MVP]

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question