Enter Parameter value (1 Viewer)

Joy83

Member
Local time
Yesterday, 17:13
Joined
Jan 9, 2020
Messages
116
Hi,
I have deleted a field in one of the tables in my access file.
Now when I run the interface main file I started ti see this new window asking me about parameters of other fields that I didn’t remove.

I went through the code the queries
I don’t see anything relevant to the field that I removed.

is there any thing specific that I need to do.
maybe there is something that I am missing
 

Attachments

  • E10F639F-90EB-49B3-BCD2-1219B25C7EBD.jpeg
    E10F639F-90EB-49B3-BCD2-1219B25C7EBD.jpeg
    339.5 KB · Views: 72

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:13
Joined
May 7, 2009
Messages
19,169
is your form based on a Query, check the query for the left-over field name.
check also the controlsource of each controls.
 

Joy83

Member
Local time
Yesterday, 17:13
Joined
Jan 9, 2020
Messages
116
In my main form
I have three subforms that I am loading
That’s all
But I checked each one of them
They don’t include that field


What do you mean by left over field name
i checked the controls as well
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 08:13
Joined
May 7, 2009
Messages
19,169
you check carefully, the query, the controlsource of each controls on mainform/subforms.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 00:13
Joined
Feb 19, 2013
Messages
16,553
Also check the filter and sort properties of your table and queries and forms that use the table
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 19:13
Joined
Feb 28, 2001
Messages
27,001
If there is a multi-layered query, the "asking for other fields" problem would be caused by the layered (not top-level) query failing and dragging all of its referenced fields down with it.
 

Users who are viewing this thread

Top Bottom