By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,392 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Adding a new field to an existing form

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
I knew this should be easy, I just didn't know what to do.

Thank you for the help.

Randy
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.