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

Adding a New Field to an existing Form

P: n/a
I could really use some help with a problem I am having. I am trying
to add a new field to an existing form that combines two tables into
one form. In this same databse I have another form that exists off of
1 table and when I add a new field into the table I have no problem
adding into the corresponding form. However when I add a new field to
one of the following tables:
- Employee List & Main Profile tables (This is what the combined form
is based off of)
Basically i added a new field to Main Profile and wanted to add it
into my form as a combo box. However when I go to add it to the form
and get the wizard and it lists the fields that I can store the values
in it does not list my newly created fields just the old original
ones. What are the resaons for this and hwo do I remedy it? I hope
that I explained this in a somewhat cognizant way.

Thank You,
Tony
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
When you are using Fields from two Tables on a Form, the Form's Record
Xource is either a Query or an SQL Statement. A new Field in the underlying
Tables isn't automatically added. In Design View, click on the RecordSource
property of the Form in the Property Sheet, then click on the little box
with three dots and update the RecordSource, which will be shown in a
QueryBuilder window.

Larry Linson
Microsoft Access MVP

"Tony D." <wa*********@aol.com> wrote in message
news:93**************************@posting.google.c om...
I could really use some help with a problem I am having. I am trying
to add a new field to an existing form that combines two tables into
one form. In this same databse I have another form that exists off of
1 table and when I add a new field into the table I have no problem
adding into the corresponding form. However when I add a new field to
one of the following tables:
- Employee List & Main Profile tables (This is what the combined form
is based off of)
Basically i added a new field to Main Profile and wanted to add it
into my form as a combo box. However when I go to add it to the form
and get the wizard and it lists the fields that I can store the values
in it does not list my newly created fields just the old original
ones. What are the resaons for this and hwo do I remedy it? I hope
that I explained this in a somewhat cognizant way.

Thank You,
Tony

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.