"Enter Parameter Value" in Form

[jlcarriona]

ACCESS 2013

I have created a form to pull out information from a Query. In this form I have a text box to fill out with certain field information (e.g. company name). Once I hit Enter or click in my search button the form should be getting updated with the information matching the field that I typed, instead, I get the window asking me to "Enter Parameter Value".

*Note that I had this form running before without any problems. After changing one of the fields names and deleting another one, I started having this problem.
[IMG]Libraries\Pictures\form[/IMG]
I have already tried:


- Going to Property Sheet, Checking the record source and making sure my query doesn't have the fields that I deleted.
- Checked for misspelled fields in my macro (I used Macro Builder and ApplyFilter for my "Search" Button)
- Checked my table to make sure all fields are updated

I've been trying to solve this for hours; any help will be greatly appreciated!!

[RuralGuy]

That issue usually indicates a field name has been misspelled.

[jlcarriona]

I have checked all my fields in the form and in the Macro Builder... still have the same problem.

[June7]

Your image did not post.

Could be either the old field name or the deleted field name is still referenced somewhere, perhaps in an expression in query.

I use Rick Fisher's Find and Replace add-in to track down issues like this. Saved my sanity more than once. Cost less than $40. V-Tools is a freebie I have heard of but never used.

[jlcarriona]

I was being able to fix it, but the issue restarted every time I re-open the data base.
How I definitely fixed it: I disable the "pop up" feature from my form, saved it, closed my database, and next time I reopened it it was fixed.

...not sure if I know exactly what was going on, but it works now.

Thanks for the help!