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

Why can I not add a field to form??!!

P: n/a
MS Access 2003 on Windows XP

Sequence of steps taken to date:

1. Created 7 tables

2. Established relationships with all tables using a single primary
key; the same value in each table (plate number)

3. Started a form using "form wizard" utilizing the existing tables

4. Halfway through development of the form I needed to add a field to
one of the tables. Added field to table and saved.

5. Opened form in "design view" and picked the "field list" tool to
select the new field and add it to the form.

The new field is not in the list though the other pre-existing fields
contained within the table are in the list.

Why Not??

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 29 Dec 2004 18:24:46 -0800, TroutFisherMan wrote:
MS Access 2003 on Windows XP

Sequence of steps taken to date:

1. Created 7 tables

2. Established relationships with all tables using a single primary
key; the same value in each table (plate number)

3. Started a form using "form wizard" utilizing the existing tables

4. Halfway through development of the form I needed to add a field to
one of the tables. Added field to table and saved.

5. Opened form in "design view" and picked the "field list" tool to
select the new field and add it to the form.

The new field is not in the list though the other pre-existing fields
contained within the table are in the list.

Why Not??


Probably because the table by itself is not the record source for the
form but a query (or SQL) is.
Open the query in design view, add the new field, and then it should
appear in the form's Field List.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
TroutFisherMan wrote:
MS Access 2003 on Windows XP

Sequence of steps taken to date:

1. Created 7 tables

2. Established relationships with all tables using a single primary
key; the same value in each table (plate number)

3. Started a form using "form wizard" utilizing the existing tables

4. Halfway through development of the form I needed to add a field to
one of the tables. Added field to table and saved.

5. Opened form in "design view" and picked the "field list" tool to
select the new field and add it to the form.

The new field is not in the list though the other pre-existing fields
contained within the table are in the list.

Why Not??


The field list show fields from the RecordSource of the form. What is that? I'm
guessing it's a SQL statement that explicitly selects fields from the original
table structure. If so you will need to modify it to include the new field(s).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.