invalid control properties: control source no such field in field

[Guest]

Having created an access database with all the fields some time ago, I now
need to add additional fields but find the above error tagged onto the new
field in design view and #Name? displayed in the form view. On looking at
the properties, there is no new field name from the drop down list in the
control source and I cannot see what the difference is in the properties of
the older fields compared to the newer fields.

Perplexed, Sue.

 

[Keith Wilby]

Having created an access database with all the fields some time ago, I now
need to add additional fields but find the above error tagged onto the new
field in design view and #Name? displayed in the form view. On looking at
the properties, there is no new field name from the drop down list in the
control source and I cannot see what the difference is in the properties
of
the older fields compared to the newer fields.

Perplexed, Sue.

Hi Sue,

I'm guessing that your form is based upon a query rather than the table
you've just modified. Check that the form's query includes your new fields
from the table.

Regards,
Keith.
www.keithwilby.com