The Receipt Form

The Receipt Form answers the question:

Who bought what?

 

This Form will combine data from three Tables.

Who: tblCustomers

Bought: tblMovieRented

What: tblMovies

 

In the following pages, we will create two new Tables that will be the Record Sources for the Receipt Form and ReceiptSubform.

 

The Receipt Subform will inherit three Key Fields from the Receipt Form. So the Table for the ReceiptSubform, tblMovieRented, has to be designed with that in mind.

Microsoft Office Access 2010: Example of the Completed Receipt Form