Adding new fields to existing forms

[Alan in Canterbury]

This has been covered before but the answers provided did not work for me. I
created a form from a table using the wizard and selected particular fields.
I then added new fields to the table. When I go to the fields list the new
fields are not on the list.

 

[Brendan Reynolds]

The form wizard creates a form based on a SQL statement along the lines of
"SELECT ThisField, ThatField, TheOtherField FROM TheTable". If you later add
another field, you need to edit the SQL statement (you'll find it in the
Record Source property on the Data tab in the Properties window) to include
the new field, e.g. "SELECT ThisField, ThatField, TheOtherField, MyNewField
FROM TheTable".

--
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.