QUESTION ? ACCESS 2007

P

Patrick Carbonneau

Recently I have created a new database (datasheet) which contained a list of
defined fields I have program it before. Following that I have created a new
FORM using FORM (TOOLS) it has replicated all my originated fields as well
as, my data input field..no problem at all.

The type of problem I have is when I am adding a new field within my
database (datasheet) it does not added automatically though my FORM. What can
I do to resolve this problem ?

Thanks

Patrick
 
C

Chris Reveille

You can't. When adding a new field to a table you will also have to add it
to the query(if used) and form for it to be visible.
 
J

John W. Vinson

On Wed, 25 Apr 2007 08:00:02 -0700, Patrick Carbonneau <Patrick
Recently I have created a new database (datasheet) which contained a list of
defined fields I have program it before. Following that I have created a new
FORM using FORM (TOOLS) it has replicated all my originated fields as well
as, my data input field..no problem at all.

The type of problem I have is when I am adding a new field within my
database (datasheet) it does not added automatically though my FORM. What can
I do to resolve this problem ?
Click to expand...

Open the Form in design view. Use the "Field List" tool on the toolbar, and
drag the new field onto the form.

If the field isn't there, view the Form's Properties; on the Data tab click
the ... icon by the Record Source property. A Query Design window will open;
add the new field to the query, close it, and accept Access' offer to save the
SQL. Then go to the previous step.

John W. Vinson [MVP]
 
Top