Can't Add Fields to Form

  • Thread starter Thread starter Jeff Miller
  • Start date Start date
J

Jeff Miller

Hello,

I am using Access 2002SP3, and I am having a problem adding fields to a
form. Hoping I'm posting to the right newsgroup.

I have 3 tables in the database. I successfully created a form, using
fields from each of the tables. However, after adding fields to one of
the tables, and wanting to then add those new fields to the form, I can
not find any of the new fields on the list.

Here's how I'm trying: I am in the Design view of the form, and I'm
clicking the "Field List" icon. The window comes up with fields from
all three tables, but none of the new ones.

Is there something I need to do, in order to get these new fields
visible? I should mention that I used the "Create Form by Using
Wizard" option.

I'm happy to answer any questions that might be able to give you
additional information. Although I have used Access for a couple of
years, I would describe my experience level as fairly low, with this
program.

Thanks
 
Look at the Record Source property of the form. To include fields from more
than one table, you must be using either a SQL statement or the name of a
saved query as the record source. The new fields will have to be added to
the SQL statement or the saved query before they will be visible to the
form.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Is that form based on the tables, or on a query? Most likely, it is a
query, and you will need to update your query with the new fields first.

Rick B
 
Brendan,

I was using an SQL statement (unknown to me - this must have been created when
I used the Wizard to establish the form.)

I did as you suggested and went to the Record Source property, added the
fields to the SQL statement, and everything works fine now. Thank you.

--
Jeff Miller
Wooster, OH USA
www.BizEthics.org


----- Original Message -----
 
Hi Rick B,

The form was based on the tables. I followed the suggestions made by
Brendan (adding fields to the SQL statement that was created as a result of
the Form Wizard). The fields are now visible, and I was able to add them
to the form.

Thanks for your help.

--
Jeff Miller
Wooster, OH USA
www.BizEthics.org


----- Original Message -----
 
Back
Top