Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-15-2019, 08:18 AM   #1
LBC
Newly Registered User
 
Join Date: Nov 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
LBC is on a distinguished road
Unhappy Access form Parameter error

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!

LBC is offline   Reply With Quote
Old 11-15-2019, 08:19 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,472
Thanks: 58
Thanked 1,416 Times in 1,397 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access form Parameter error

Hi. Welcome to AWF!


Did you search your form for any reference to the deleted fields?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-15-2019, 08:32 AM   #3
Fira_g
Newly Registered User
 
Join Date: Oct 2019
Posts: 60
Thanks: 5
Thanked 1 Time in 1 Post
Fira_g is on a distinguished road
Re: Access form Parameter error

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

Fira_g is offline   Reply With Quote
Old 11-15-2019, 08:39 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,472
Thanks: 58
Thanked 1,416 Times in 1,397 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access form Parameter error

Quote:
Originally Posted by Fira_g View Post
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.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 11-15-2019, 03:03 PM   #5
LBC
Newly Registered User
 
Join Date: Nov 2019
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
LBC is on a distinguished road
Re: Access form Parameter error

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.
LBC is offline   Reply With Quote
Old 11-15-2019, 03:04 PM   #6
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 6,472
Thanks: 58
Thanked 1,416 Times in 1,397 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Access form Parameter error

Quote:
Originally Posted by LBC View Post
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.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Reply

Tags
enter parametre value , new record

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR: Enter Parameter when closing form chuckcoleman Forms 5 02-19-2019 09:20 AM
Parameter qry Error (3061) Parametr is TextBox on a form andrewboast Queries 4 06-15-2016 03:25 AM
Enter Parameter Value Error : Form/SubForm mpspeer Forms 5 11-12-2012 12:15 PM
Parameter error when opening form Accessible92866 Forms 3 11-06-2008 11:32 AM
Enter Parameter Value on form close error maxcess Forms 4 06-21-2005 01:27 PM




All times are GMT -8. The time now is 06:24 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World