Update forms after updating table

[Guest]

Hi,

I am relatively new to Access.

I have added a new column/field to my Table. I have already created a form
from this Table but this new field doesn't appear in the form. How do I add
the new field to the already created forms?

Thanks!
Jesse

 

[Douglas J. Steele]

Is your form based on the table, or on a query based on that table? If the
latter, you'll need to ensure that the query is updated to include the new
field.

Once you've done that, add a textbox onto your form, and look at the
pull-down list that'll be present for its ControlSource property.

 

[Guest]

I received assistance on the same issue. Select Design View on the Form.
Select View on the Tool Bar and click the Field List icon. Find your newly
created Field and drag and place it on your form.

 

[Guest]

I've had the same problem, however, the new columns (fields) I added to the
Table do not show up in the Field List. They do show up in the Tables in the
Relationship window. I am pulling the information from the Tables directly
to a Form, no query. Am I doing something wrong?

 

[Guest]

I have the same problem. The new field does not show up in the field list.
I am not using a query. How do I change the Select statement for the form?

 

[Dirk Goldgar]

In

I have the same problem. The new field does not show up in the field
list. I am not using a query. How do I change the Select statement
for the form?

Open the form in design view. Open the form's property sheet. On the
Data tab, click on the "Record Source" line. If the record source is
just the name of a table, drop down the list, then reselect the table.
If the record source is a SELECT statement, click the build button
(caption "...") at the end of the property line to edit that statement
in the query designer. When you close the query design window, you'll
be asked if you want to save the changes and update the property; click
Yes.

 

[Guest]

Thanks a million, Dirk. I appreciate the help.

Tom