Deleting Fields from a form

S

smeldawg

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?
 
K

Klatuu

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.
 
J

John W. Vinson

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