Adding a field to an existing form

[Jennifer]

Sorry for this very basic question but I can't find the answer in the help.

I have an existing form. I have added a field to a table that is already
linked to the form. How can I get the new field to show up in the list of
fields defined for the form? I don't want to have to create the form from
scratch just to get this one field included.

Thanks
Jennifer

 

[Rick Brandt]

Sorry for this very basic question but I can't find the answer in the help.

I have an existing form. I have added a field to a table that is already
linked to the form. How can I get the new field to show up in the list of
fields defined for the form? I don't want to have to create the form from
scratch just to get this one field included.

You're assuming that the form wizard bound your form to the table directly. It
didn't. What it did was create a SQL statement pointing at your table. On top
of that instead of using "SELECT * FROM..." which *would* pick up any new field
you might add, it selected fields explicitly, "SELECT YourTable.Field1,
YourTable.Field2, etc.".

With this type of SQL statement any new fields you add to your table are not
automatically added to the query. So you have to edit the SQL that the form is
using to include your new fields. Then they will appear in the fields list for
the form.

Just go to the RecordSource property for the form and press the build button
[...] at the right of the entry. The Query designer will be displayed where you
can modify the query and save the changes.