Adding A New Field to a Form

[Guest]

Since creating our orginal form we have added more fields to our table. We
would now like to add these fields to our form.

-When I click the display box, these new fields are not in the list of
fields shown.
-When I go to the wizard option the table where I want the information from
is not listed - I get Expression, Marco and Code builder instead.
-If I create a new form with wizard and select these new fields I can cut
and paste them into our orginal form. However I get an error message saying
the fields have an invalid control cource property which I don't know how to
fix.

Any suggestions?

 

[Ken Snell \(MVP\)]

Most likely, your form's RecordSource is an SQL statement or a query that
does not include the new fields in the fields being selected in the query.
You'll need to modify the RecordSource's SQL statement or query to add the
new fields.

 

[Carl Rapson]

Since creating our orginal form we have added more fields to our table. We
would now like to add these fields to our form.

-When I click the display box, these new fields are not in the list of
fields shown.
-When I go to the wizard option the table where I want the information
from
is not listed - I get Expression, Marco and Code builder instead.
-If I create a new form with wizard and select these new fields I can cut
and paste them into our orginal form. However I get an error message
saying
the fields have an invalid control cource property which I don't know how
to
fix.

Any suggestions?

If you originally built the form using the wizard, it's likely that the
form's Record Source is actually a SELECT statement instead of just the
table name. If that's the case, you'll need to edit that SELECT statement to
include the new fields. The new fields should then appear in the box.

Carl Rapson