QUESTION ? ACCESS 2007

[Guest]

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

 

[Guest]

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.

 

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

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]