Create a form by using the Form tool

You can use the Form tool to quickly create a single item form. This type of form displays information about one record at a time, as shown in the following illustration:

A single item form

1. The form displays information for a single record.

2. In some cases, Access adds a subdatasheet to display related information. For more information, see the section Automatic subdatasheet creation.

When you use the Form tool, all the fields from the underlying data source are added to the form. You can start to use the new form immediately, or you can modify it in Layout view or Design view to better suit your needs.

Tip    Access 2010 includes tools that help create professional looking forms more easily.  

Create a single item form

  1. In the Navigation Pane, click the table or query that contains the data that you want to see on the form.

  2. On the Create tab, in the Forms group, click Form.Button image

    Access creates the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data. For example, you can adjust the size of the text boxes to fit the data. For more information about form views, see the article Which view should I use: Layout view or Design view?.

  3. To begin working with the form, switch to Form view:

    • On the Home tab, in the Views group, click View, and then click Form View Button image.

Automatic subdatasheet creation

If Access finds a table that has a one-to-many relationship with the table or query that you used to create the form, Access adds a subdatasheet to the form that is based on the related table or query. For example, if you create a simple form that is based on the Customer table, and there is a one-to-many relationship defined between the Customer table and Orders table, the subdatasheet displays all the records in the Orders table that pertain to the current Customer record. If you decide that you do not want the subdatasheet on the form, you can delete the subdatasheet by switching to Layout view, selecting the datasheet, and then pressing DELETE.

If there is more than one table with a one-to-many relationship to the table that you used to create the form, Access does not add any datasheets to the form.

Top of Page

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language