add news fields

  • Thread starter Thread starter Chink!
  • Start date Start date
C

Chink!

hello

I have an existing database with a form set up to access all the fields.

I want to add some new fields to the form.

I have entered the fields in the table in design view and they are shown.
However when I go to form view and click on the Form list the new fields are
not shown

What am I doing wrong?


thanks
CH!
 
Hi,

Check the recordsource for the form, be sure it is the tablename and not
either a list of
fields or a query.

HTH -Linda
 
Novice at Access here, but you have to add the new fields to the form
as well, or build another form using the wizard. That will then pick
up the new fields. If you have a lot of code in the existing form,
then just drag and drop the new fields to where you want on the form.
If you haven't a lot of code or made a lot of mods to the form, just
build a new one.

hello

I have an existing database with a form set up to access all the fields.

I want to add some new fields to the form.

I have entered the fields in the table in design view and they are shown.
However when I go to form view and click on the Form list the new fields are
not shown

What am I doing wrong?


thanks
CH!
Click to expand...

Please remove obvious from email address if emailing.
 
hello

I have an existing database with a form set up to access all the fields.

I want to add some new fields to the form.

I have entered the fields in the table in design view and they are shown.
However when I go to form view and click on the Form list the new fields are
not shown

What am I doing wrong?

thanks
CH!
Click to expand...

If the new table fields do not show in the form's field list tool
button, then the recordsource for the form is not the table but a
query. Add the new fields to the query and they will show on the field
list.
 
If the new table fields do not show in the form's field list tool
button, then the recordsource for the form is not the table but a
query. Add the new fields to the query and they will show on the field
list.
Click to expand...

You are quite right
The form is set to use the query as its source

many thanks for your replies


CH!
 
Yes, this is access trying to be clever.
In foxpro and access you can select *, but access then replaces that
with the current fields in the table. If it left it at * as foxpro
does then you would pick up the new fields automatically.

Some people even recommend this so that you ahve all the fields for
developing reports etc, and do not have to go thru what you have just
discovered.

You are quite right
The form is set to use the query as its source

many thanks for your replies


CH!
Click to expand...

Please remove obvious from email address if emailing.
 
I can not reproduce this. Access does not do this when I save a query, or
when I bind a form to a SQL statement. Perhaps you might tell us under what
circumstances you have seen Access do this?

--
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.
 
I just tried it now and it stays the same. I could have sworn the last
time I did that some time ago, it caught me out.


I can not reproduce this. Access does not do this when I save a query, or
when I bind a form to a SQL statement. Perhaps you might tell us under what
circumstances you have seen Access do this?
Click to expand...

Please remove obvious from email address if emailing.
 
Back
Top