Subform: Select the Fields

The next step in the Subform Wizard asks you to choose which Field(s) will be used to link the Master Form to the Child, the Subform.

 

We will select three Fields which the Subform will inherit. For example, when a CustomerID is selected with the Combo Box on the Parent Form it will be saved to tblMovieRented in the Child, or Subform as well.

 

2. Try it: Select a Field

The default option is: Choose from a list.

Select: Define my own.

 

Select a Form/report Field: ReceiptID

Select a Subform/subreport Field: ReceiptID.

 

Select a Form/report Field: CustomerID

Select a Subform/subreport Field: CustomerID.

 

Select a Form/report Field: DateRented

Select a Subform/subreport Field: DateRented.

 

Click Next. Keep going...

Form Design Tools->Design->Controls->Subform/Subreport

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: Add a Subform