when I enter a NEW FIELD into my table and then open my form this is not included !

[jagstirling]

I am an Access 'newbie' ....... learning slowly bit by bit ....... my current probelm is this;

I have a form that is created from a table that has 5 fields and 13 records.

When I enter a NEW RECORD in my table and open my form, this record is clearly visible.

However, when I enter a NEW FIELD into my table and then open my form this is not included !

Is there any way around this (I have 'formatted' the form so would be grateful if any suggestions would not involve rebuilding the form if possible).

Many thanks.

 

[Rickster57]

fields

After adding a field to your table you have to go into design view of your form, add a text box with that field as the data source.

 

[jagstirling]

Is there no way of automatically adding the field ?

 

[KeithG]

No I don't believe soo.

 

[GohDiamond]

Generally all objects in Access act in a similar fashion.
When your Design or Redesign an underlying Table or Query you have to Design or Redesign the Form to display the fields you want to edit or read, unless its a datasheet view.

If the underlying table shows up in the Form or subform as a Datasheet then any fields added to that table should automatically display in the next column to the right in the datasheet.

If the form datasheet is based on a query, you have to edit the query to make sure the field you added to the Table is included, unless you used the * in the query to include all table fields.

Goh