Access: Screen Play Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Example of a Form with a Subform

The Receipt Form

A receipt form answers the questions, “Who bought what?” This form will combine information from three tables:

Who: tblCustomers

Bought: tblRental

What: tblMovieTitles

 

You need a new table that will store all of this information. This new table will also be the record source for your Receipt form.

 

There are several steps in this process. None of the steps are difficult, it just takes a little time to setup.

 

Memo to self: There are some sample databases available online.