Access form Parameter error (1 Viewer)

LBC · Nov 15, 2019

I have a form which has been working fine. I recently deleted three fields in the table and now whenever I open the form or try to enter nay data into the form, I have an error pop up x2 "Enter parameter value") for the three deleted fields. I have tried everything but cannot get rid of this. Also, the enter new record button has disappeared/is greyed out (so now I can only entre records via the table not the form). Please help!

theDBguy · Nov 15, 2019

Hi. Welcome to AWF!

Did you search your form for any reference to the deleted fields?

Fira_g · Nov 15, 2019

I had this problem, didn't know at the time that need to delete fields from the Record Source of the form as well )

theDBguy · Nov 15, 2019

Fira_g said:
I had this problem, didn't know at the time that need to delete fields from the Record Source of the form as well )

Yes, that would be the first place to look. Don't forget to delete related controls as well. There are other places to look, but we can start with these first.

LBC · Nov 15, 2019

Thanks everyone. As far as I can see (when I open the field list in design view), the fields are no longer there, but the error keeps appearing.

theDBguy · Nov 15, 2019

LBC said:
Thanks everyone. As far as I can see (when I open the field list in design view), the fields are no longer there, but the error keeps appearing.

No, not just in the Fields List. Check for any control on your form that may still be referring to the deleted fields. In addition, check the Filter and Order By properties of the form.

Access form Parameter error (1 Viewer)

LBC

New member

theDBguy

I’m here to help

Fira_g

Registered User.

theDBguy

I’m here to help

LBC

New member

theDBguy

I’m here to help

Similar threads

Users who are viewing this thread