Form/Subform and a changed table

[Guest]

I realized that my subform (table) needs another field. I went back to the
table and addied a field, and entries for the previous records.
When I went to the subform to add the field, and went to field list, I did
not see the new field. How can I add the field, or do I have to delete the
subform and then recreate the subform?

 

[Jeff Boyce]

A common practice in creating forms/subforms is to use a query as the
source, rather than going directly to the table. Is there a chance your
form (subform) is "fed" by a query, which might not "know" about your new
table?

Another possibility -- Is there a chance you have a split
front-end/back-end, and you made changes in the back-end definition of the
table without re-linking to it from the front-end?

Regards

Jeff Boyce
<Office/Access MVP>