Adding a field after creating a form from a 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?!

 

[Tim Johnson]

Here's what it sounds to me like you need to do:

1.) Open the form in design view
2.) If it isn't already open, open the properties dialog for the form (this
can be done by right-clicking on the square in the upper left where the
rulers intersect and selecting Properties
3.) In the Properties dialog, click on the Data tab
4.) To the right of the RecordSource, you should see a SQL statement, if you
click in that box, a button will appear to the right of it with "..." as it's
caption. Click on that.
5.) You will open the query wizard, which you should be familiar with.
Locate the field that you want from the appropriate table in this screen and
drag it down to the appropriate "Field:" location below.
6.) Close the query wizard (the black "x" in the upper right, not the red
one); you will be promted to save, click on yes
7.) There you go, your field should now be available in the field list of
the form.

 

[John W. Vinson]

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?!

Open the Form in design view, and view its Recordsource property. Click the
.... icon by it to open it in the query design window. Add the new field, close
the query design window, and accept Access' offer to save the property.

Note that a 7-table query as the basis for a Form is almost certainly A Bad
Idea; it's not likely to be updateable, and will show strange results with
repeating values in the "one" side table, or records missing altogether if
there is no matching record in the related table. You're almost certain to be
better off by using a Form for the "one" side with a Subform for the "many"
(with multiple subforms or sub-subforms as needed), and with Combo Boxes for
your "lookup" tables.