Newly entered item in Table not showing in Field List of form

[julie]

Hello all,

I have and existing form that I need to add a field to. I added the
item to the Table that the form pulls from, but when I go back into
the form, the new item does not appear in the Field list for me to add
it to the Form. When I try to add it manually, I get the ?Name# error
in the text box. I've had this problem before (Aug 7) and ended up
recreating the entire form just for one addition. I really don't want
to have to do that again. Also, the answer from Aug 7 said that
having seven tables feed into one form was too much, but in all the
training classes I've had and all the books say the more tables the
better...that it's better to have many small tables related, than one
big huge table. What gives?

 

[Ron2006]

First question only:

Is the Recordsource on the Data Tab of the form the table/query or is
it a "SELECT...." statement.

If it is SELECT then press the .... button on the right side and add
the new field in the query.

If the recordsource is a separately saved query then open the query in
design view and add the field there.

Ron

 

[julie]

THANK YOU Ron. I am no longer going crazy.