GCFLearnFree.org

I love you guys!”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access 2013
  • Creating Forms

Access 2013

Single page view print copy

Creating Forms

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, those 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 Design tab, then locate the Tools group on the right side of the Ribbon.
  2. Click the Add Existing Fields command.
    Screenshot of Access 2013Clicking the Add Existing Fields command
  3. The Field List pane will appear. Double-click the desired field(s).
    Screenshot of Access 2013Selecting a field from the source table
  4. The field will be added.
    Screenshot of Access 2013The 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.

Screenshot of Access 2013Clicking the Blank Form command

To add a field from a different table:

You can also add fields from different tables in your database to the form.

  1. From the Field List pane, click Show All Tables.
  2. Click the plus sign + next to the table that contains the field you wish to add, then double-click the desired field.
    Screenshot of Access 2013Selecting a field from another table
  3. The new field will be added.
previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.