Adding More Fields to Existing Form

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have already created a database and have already input
some records. I need to add more columns to the database
and have added them to the Table but need them added onto
the Form Datasheet. Is there as way to add these new
colums to the Form Datasheet without having to recreate
everything and reinput the information?
 
Check the Form's RecordSource property.
If the table is the record source for the form, the new fields will appear
in the Field List toolbutton as soon as you add them to the table.

However, if the record source of the form is a query or SQL, then you'll
need to first add the fields to the query/SQL first. Then they will appear
in the Field List.

Click on the Record Source property line.
Click on the button with the 3 dots that appears on that line.
Drag the new fields from the table to the query grid.
Save the changes.

Drag the fields from the fields list and place them on the form.
 
Back
Top