Adding control after form is created using wizard

[julie]

I have created a form using the wizard, from 7 different tables.
After completing the wizard, I realized I left a field of of a table.
I went back to the table, added the field, and am now having trouble
adding that new field to the form. The new field is not listed in
the
Field List, nor in the properties box of a new control that I create
from scratch. Also, when I do enter the tbl name in manually, I get
an error in Form view when I try to add data: "Control can't be
edited; it's bound to unknown field..." and in the text box, it
populates itself with #Name?, which can not be deleted. I've tried
everything that every book and help website and training class is
offering. Short of recreating the form, what can I do?! (access 2003)

 

[fredg]

I have created a form using the wizard, from 7 different tables.
After completing the wizard, I realized I left a field of of a table.
I went back to the table, added the field, and am now having trouble
adding that new field to the form. The new field is not listed in
the
Field List, nor in the properties box of a new control that I create
from scratch. Also, when I do enter the tbl name in manually, I get
an error in Form view when I try to add data: "Control can't be
edited; it's bound to unknown field..." and in the text box, it
populates itself with #Name?, which can not be deleted. I've tried
everything that every book and help website and training class is
offering. Short of recreating the form, what can I do?! (access 2003)

If your form is getting data from 7 different tables, that means a
query (or SQL) is the record source for the form. You first need to
add the field to the query, then it will be available in the field
list.
However, with that many tables, it's possible that your form is NOT
editable.
See Access help on:
Query + Troubleshoot query + Specific Type of Query + Select Query + I
can't update data from a query.