deleting fields from tables

[ronaldff]

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

Access 2007: Windows XP Home

 

[DCrake]

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

 

[ronaldff]

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

 

[DCrake]

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

 

[ronaldff]

hi David

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

Ron

 

[SOS]

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 which has a thing called TOTAL DEEP SEARCH. It should help you to find the problem.

 

[ronaldff]

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