DBWebApplications 





Access Data Manipulation  «Prev  Next»
Lesson 3 Creating an AutoForm
Objective Create an AutoForm from the fields in one table.

Creating an AutoForm

Using the AutoForm feature is the easiest way to create a form. An AutoForm is a form created from one table: it displays all the fields in the table for one record at a time. If the table has subdatasheets, the AutoForm automatically creates a subform to display the subdatasheet.
There is more than one way to create an AutoForm. The steps below take you through the easiest way to create one: using the New Object button on the database window toolbar.
Window Toolbar
Window Toolbar

  1. The New Object button is the second to last button on the toolbar as shown here. You simply click the down arrow next to the New Object button to see the list of new objects, then select the AutoForm option.


Autoform Option
Autoform Option
  1. Access creates an AutoForm using the table that you selected. Because the Projects table had the Hours table defined as a subdatasheet, this form actually has two sections – the fields from the Projects table, and, at the bottom, a datasheet-like presentation of the fields in the Hours table.
  2. When you close the form, Access will ask you if you want to save it. You can choose to use the name Access suggests (which will be the same as the name of the table the form is based on) or you can type a new name.
An AutoForm is a good way to create a form that you can then edit to make the form you really need.
Learn to display different records in a form, in the next lesson.