Can't add Field to existing Form

[shill]

When I add a new field to a table the new field then does not show up in design mode in an existing form. The new field does not show up in the field list. If I add a text box and change the properties and set the control source it then shows a #name error.

Help, any suggestions?

 

[SomeGuy]

You might want to check and see if the form source is a query of the table and not the table itself.

I've caught myself doing that one before. Any changes in the table fields will not show up in the field list but if you change it in the query, it will.

Just a thought.

 

[shill]

Thanks for the response. I checked and the form is based on a table in fact it was based on two tables using the wizard to create it. Should it be based on a query since it is using more that one table?
Thanks

[This message has been edited by shill (edited 01-02-2001).]

 

[TGHockett]

shill ... I think SomeGuy probably has your problem in focus, unless you are using a master form with a sub-form for the 2nd table?

If you give us a generic description of what you are trying to accomplish, one of us can probably help you figure out the best way to go ... good luck.

TGH