DATABASE

Creating a Form by Using AutoForm

AutoForm creates a form that displays all fields and records in the underlying table or query. If the record source you select has related tables or queries, the form will also include all the fields and records from those record sources.
  1. In the Database window, click Forms 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.

  4. Click the table or query that contains the data you want to base your form on.

  5. Click OK.


    Microsoft Access applies the last autoformat 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.