Re: Can't Add Fields to Form

From: Brendan Reynolds (brenreyn)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 19:29:08 -0000

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.
"Jeff Miller" <jeff@BizEthics.org> wrote in message 
news:VA.0000035e.1fa23998@bizethics.org...
> 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
>
> --
> Jeff Miller
> Wooster, OH  USA
> www.BizEthics.org
>

Relevant Pages

  • =?UTF-8?B?UmU6IEJhc2luZyBhIGZvcm0gb24gU1FMIGFzIG9wcG9zZWQgdG8gYSA=?= =?UTF-8?B?dGFibGUgb3Igc
    ... If the SQL statement that you are passing to the forms record source is not updatable then the data in your form will also not be updatable. ... A pass-through query sends commands directly to ODBC databases, such as Microsoft FoxPro, using commands that are accepted by the server. ...
    (microsoft.public.access.formscoding)
  • Re: Retriving data from DB
    ... rsRecordset("Name"), which name would I get from the recordset, the first ... > the fields in your table and generate this sql statement for you (and even ... > post to an Access newsgroup for help. ... >> tblSchedule and tlbScheduleAdd ...
    (microsoft.public.inetserver.asp.db)
  • Re: insert into error
    ... > Microsoft JET Database Engine ... > I've done a response.write with the SQL statement and I get this ... it's silly to be forced to worry about delimiters (let alone ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to select rows from a mapped protected .MDB and insert into local table
    ... your concatenation will look like (your tables don't have fields called ... us the actual sql statement. ... you would have to try it in the Access Query Builder to be sure. ... You may need to take this to an Access newsgroup to get Jet-specific ...
    (microsoft.public.data.ado)
  • Re: Variable Type?
    ... > The data length of COSTCENTRE is 12. ... > The data length of BUSINESSUNIT is 12. ... resulting in a correct sql statement. ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)