Microsoft Office Access 2010: Example of a Form with a Subform in Design View

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.