Adding a new field to an existing form

[Randy A. Bohannon]

This is probably a simple thing to do, but I can't find how in the help
files or the manual I have.

I'm using Access 2000. I have three tables joined by a common field, and
I'm using one form to enter data into all of them. The form was created
using the form wizard. I need to add new fields to one of the tables, and
consequently, to the form. I can add the fields to the table, but not to
the form. I've done this before with a form tied to a single table. The
field list is updated when the table is. But now the field list is not
being updated. When I try to insert a control on the form and set the
control source to the field in the table (either manually or by using the
expression builder), I get a message saying "Control can't be edited; it's
bound to the expression '[TableName]!FieldName' ."

The tables are each relatively small, but I don't want to have to create a
new form to add the new fields.

I would very much appreciate any help on this.

Randy

[Larry Linson]

You will need to manually modify the RecordSource property of the Form -- it
is likely in the form of an SQL statement, but if you click on the three
dots at the right, will bring up the Access Query Builder. You can then drag
down the new fields into the RecordSource, and it is from the RecordSource
that the Field List is populated. And, yes, it is a fact that a Control
Source must be an expression (not bound, not updateable) or a Field from the
RecordSource.

Larry Linson
Microsoft Access MVP

"Randy A. Bohannon" <bo******@rr.com> wrote in message
news:pO********************@twister.nyroc.rr.com.. .

This is probably a simple thing to do, but I can't find how in the help
files or the manual I have.

I'm using Access 2000. I have three tables joined by a common field, and
I'm using one form to enter data into all of them. The form was created
using the form wizard. I need to add new fields to one of the tables, and
consequently, to the form. I can add the fields to the table, but not to
the form. I've done this before with a form tied to a single table. The
field list is updated when the table is. But now the field list is not
being updated. When I try to insert a control on the form and set the
control source to the field in the table (either manually or by using the
expression builder), I get a message saying "Control can't be edited; it's
bound to the expression '[TableName]!FieldName' ."

The tables are each relatively small, but I don't want to have to create a
new form to add the new fields.

I would very much appreciate any help on this.

Randy

[Randy A. Bohannon]

I knew this should be easy, I just didn't know what to do.

Thank you for the help.

Randy