Deleting Fields from a form

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

Guest

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]
 

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

Similar Threads

form won't let me delete field 3
Deleted a field from form & table. "Enter parameter value" message 5
Parameter Value 0
Enter Parameter Value error message 4
Access Invalid bracketing of parameter name 1
Access How to remove a non-existent field from a form's Field List 0
Outlook Creating an Outlook form 2
Access Automatically Send a notification email once a record is added 0

Top