Data Entry: Form and Subform
Forms
and Subforms let Users record one-to-many transactions. For
example, a Receipt Form has the customer's name on the top Form and
the movies that were rented listed in the Subform on the bottom.
When business
is good many customers return many times and rent many movies. A
Receipt Form is also an example of a many-to-many relationship.
So, we will spend some time on the Receipt Form in the
Advanced Guide to Microsoft Access 2010.
The
Intermediate lessons will create two forms that work with the Movie
Table: a data entry form and a search form. We will also add a
little programming to the Form Controls so that the records update
automatically when the User makes a selection.
So far, so
good.