Deleting Fields from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
None of the fields i deleted are part of any query
Click to expand...

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]
 
Back
Top