graphic1

The Receipt Form, part 2

The Receipt Form should work like this: You should be able to type in a customer phone number and have the Form display the name and address. So, this Form needs a Combo Box that will look up the phone number, a Query that will find the name and address that matches that phone number, and a little bit of formatting to make it happen. 

graphic2

In Receipt Form, part 2, the focus will be on the Receipt Form. This Form will list the movies rented.

 

This is the "one" part of the one-to-many relationship. One customer gets many movies.

 

This lesson will begin by designing a new Record Source for this Form: a Select Query.

 

Microsoft Access: Example of the completed Receipt Form