Enter Parameter Value on open table in FE

  • Thread starter Thread starter M Skabialka
  • Start date Start date
M

M Skabialka

I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?
 
I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields until
it looked right.  Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end.  I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE.  Where is this nag coming from
so I can get rid of it?
Click to expand...

Delete the linked table in the front end and recreate it.
 
This worked - thanks.
Mich

I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?
Click to expand...

Delete the linked table in the front end and recreate it.
 
I thought it was fixed but after closing the database and reopening it, the
form the table is used on still gets the Enter Parameter Value window for
that deleted field.

So relinking has NOT fixed the problem.
Where else could it be hiding? I don't want to leave an unused field in the
table just to get rid of the prompt.


I created a new table in the back end, and linked it to the front end.
After going back and forth a few times I added fields, removed fields
until
it looked right. Now when I open it in the front end a window pops up
asking me to Enter Parameter Value, and it indicates a field I deleted.
I recreated the field in the back end, it opens OK in the front end. I
delete it in the BE and the FE asks for the parameter value.

I have removed all filters in the BE and FE. Where is this nag coming from
so I can get rid of it?
Click to expand...

Delete the linked table in the front end and recreate it.
 
Check all the controls on your form to ensure none of them are referring
to the deleted field (perhaps in a calculation)

Check the code behind the form to see if there is any reference to the
missing field.

Check the recordsource for the form (perhaps it's a SQL statement or a
saved query rather than your table).

Joan Wild
MS Access MVP
 
Check all the properties of the table (in design view, choose
properties) - not just the filter property, but also the sort order.

Check all the properties of each field in the table (perhaps a
validation rule, possibly lookup properties?)

Check the indexes you have defined for the table.

Joan Wild
MS Access MVP
 
Back
Top