Creating Forms

Creating forms in Access can make entering data more convenient. Learn how to create and modify Access forms here.

Adding additional fields to a form

When you use the Form command on an existing table, all of the fields from that table are included in that form. However, if you later add additional fields to that table, these fields will not automatically show up in existing forms. In situations like this, you can add additional fields to a form.

To add a field to a form:

  1. Select the Form Layout Tools Design tab, then locate the Tools group on the right side of the Ribbon.
  2. Click the Add Existing Fields command.
    The Add Existing Fields commandThe Add Existing Fields command
  3. The Field List pane will appear. Select the field or fields to add to your form.
    • If you want to add a field from the same table you used to build the form, double-click the name of the desired field.
      Selecting a field from the source tableSelecting a field from the source table
    • To add a field from a different table:
      1. Click Show All Tables.
      2. Click the plus sign + next to the table containing the field you want to add.
      3. Double-click the desired field.
      Selecting a field from another tableSelecting a field from another table
  4. The new field will be added.
    The added fieldThe added field

You can also use the above procedure to add fields to a totally blank form. Simply create a form by clicking the Blank Form command on the Create tab, then follow the above steps to add the desired fields.

The Blank Form commandThe Blank Form command