Create a form

There are three ways to create a form.

Based on a single table or query by using AutoForm. AutoForm creates a form that displays all fields and records in the underlying table or query (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.). If the record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.) you select has related tables or queries, the form will also include all the fields and records from those record sources.

 Tip    Try Office 2010 In Access 2010, forms have control layouts, which help keep things lined up and looking good.
Watch a video or try Office 2010.

ShowHow?

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Forms Button image under Objects.
  2. Click the New button on the Database window toolbar.
  3. In the New Form dialog box, click one of the following wizards:
    • AutoForm: Columnar     Each field appears on a separate line with a label to its left.
    • AutoForm: Tabular     The fields in each record appear on one line, with the labels displayed once at the top of the form.
    • AutoForm: Datasheet     The fields in each record appear in row-and-column format, with one record in each row and one field in each column. The field names appear at the top of each column.
    • AutoForm: PivotTable     The form opens in PivotTable view. You can add fields by dragging them from the field list to the different areas in the view.
    • AutoForm: PivotChart     The form opens in PivotChart view. You can add fields by dragging them from the field list to the different areas in the view.

ShowIf the wizard doesn't start

This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.

For more information about installing the Jet upgrade, see the Office Online article About Microsoft Jet 4.0 SP8 or later.

For more information about sandbox mode, see the Office Online article About Microsoft Jet Expression Service sandbox mode.

  1. Click the table or query that includes the data you want to base your form on.
  2. Click OK.

Microsoft Access applies the last autoformat (autoformat: A collection of formats that determines the appearance of the controls and sections in a form or report.) you used to the form. If you haven't created a form with a wizard before or haven't used the AutoFormat command on the Format menu, it uses the Standard autoformat.

ShowTip

You can also create a columnar AutoForm based on the open record source or the record source that's selected in the Database window. Click AutoForm on the Insert menu, or click the arrow next to the New Object button on the toolbar, and then click AutoForm. If the record source you select has related tables, AutoForm adds a subform that contains the related tables displayed as datasheets (datasheet: Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.) and subdatasheets (subdatasheet: A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet.).

Based on one or more table or query with a wizard. The wizard asks you detailed questions about the record sources, fields, layout, and format you want and creates a form based on your answers.

ShowHow?

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Forms Button image under Objects.
  2. Click the New button on the Database window toolbar.
  3. In the New Form dialog box, click the wizard that you want to use. A description of the wizard appears in the left side of the dialog box.

ShowIf the wizard doesn't start

This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled.

For more information about installing the Jet upgrade, see the Office Online article About Microsoft Jet 4.0 SP8 or later.

For more information about sandbox mode, see the Office Online article About Microsoft Jet Expression Service sandbox mode.

  1. Click the name of the table or other record source that includes the data you want to base your form on.

 Note   You don't need to do this step if you selected Form Wizard or PivotTable Wizard in step 3 — you can specify the record source for the form later.

  1. Click OK.
  2. Follow the instructions in the wizard.

If the resulting form doesn't look the way you want, you can change it in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.), PivotTable view, or PivotChart view.

 Notes 

On your own in Design view. You create a basic form and customize it in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.) to suit your requirements.

ShowHow?

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.), click Forms Button image under Objects.
  2. Click the New button on the Database window toolbar.
  3. In the New Form dialog box, click Design View.
  4. Click the name of the table or other record source (record source: The underlying source of data for a form, report, or data access page. In an Access database, it could be a table, query, or SQL statement. In an Access project, it could be a table, view, SQL statement, or stored procedure.) that includes the data you want to base your form on. If the form won't contain data (for example, if you want to create a form to use as a switchboard to open other forms or reports, or if you want to create a custom dialog box), don't select anything from this list.

ShowTip

  1. Click OK.

Microsoft Access displays the form in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).

 
 
Applies to:
Access 2003