Hi!

I have deleted a field from a table; however, when I open a form associated with that table, I get a window asking for a parmeter value for the deleted field - even though I have deleted the field from the design of the form.

How do I get round this?

many thanks

Ron:confused:

Access 2007: Windows XP Home

The control source of the textbox will need to be deleted as the form still thinks the field exists.

Thanks for that quick reply - I deleted the control source on the form design - but it still asks for a parmeter value.

this is a new table and form, so it has no links or queries

thnks
Ron :confused::confused:

There must be something happening with the form that is referring to this field. At what point is it asking for it?

hi David

open database, then open form - at that point it asks for parameter value

Ron

hi David

open database, then open form - at that point it asks for parameter value

Ron
You must have either a piece of code, macro, or property that refers to that field somewhere in the form. If you have trouble finding it, try using the FREE V-TOOLS (http://www.skrol29.com/dev/en_vtools.htm) which has a thing called TOTAL DEEP SEARCH. It should help you to find the problem.

Hi

Thanks for all your help. the problem has gone away!!!

would closing down the database have reset the table/form in some way?

many thanks
Ron