Adding a field to an existing form

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

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
 
Jennifer said:
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.
Click to expand...

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