Add a table as a subform in a main form.

Ensure that Use Control Wizards is turned on$.$

Use the Subform$/$Subreport button to add a subform onto the main form. Position the subform near the left border at the $2"$ high mark. The SubForm Wizard launches.

Choose Use existing Tables and Queries, add the TicketNumber, TicketDate, City, PrimaryFactor, and Fine fields from the Tickets table into the Selected Fields area in the SubForm Wizard. Also add the FirstName and LastName field from the Officers table into the Selected Fields area.

Select the Show Tickets for each record in Drivers using LicenseNumber link statement.

Enter the name TicketsSubform instead of the default name and click Finish.

Save the main form.

Switch to Layout view.

Layout view after adding the TicketsSubform onto the DriverTicketDetails main form.

Click the Next record arrow in the Navigation bar of the main form to advance to the next record. Verify that the subform updates to display one ticket for Sandra Johnson.

Switch to Design view.

Increase the width of the main form to $9"$ to provide space to see and modify the subform.

Set the following properties for the TicketSubform: Enter $8\mathrm{.}6"$ in the Width property and $\mathrm{.}1"$ in the Left property.

Save and close the form to ensure that all updates are correctly processed. If prompted, save your changes.

Customize the subform to adjust field widths and remove the border, Navigation bar, and label.

Open the DriverTicketDetails form in Layout view.

Right$-$click the TicketNumber field name and select Field Width from the context menu.

Enter $15$ in the Column Width dialog box and click OK$.$ Recall that the column widths of a subform can only be changed in Layout view.

Change the Column Width of the remaining fields using the values below. You may need to use the scroll bars to see all the fields. The completed subform should look similar to Figure $7-120.$

Layout view of the TicketsSubform form after adjusting column widths.

TicketDate: $13$

City: $12$

PrimaryFactor: $23$

Fine: $11$

FirstName: $15$

LastName: $17$

Save your changes.

Switch to Design view. If prompted, save your changes.

Click to select the TicketsSubform and enter $1\mathrm{.}2"$ in the Height property and select Transparent in the Border Style property.

Click the Select All box in the subform to select the subform. The Select All box in the subform updates to display a black square.

Select No in the Navigation Buttons property.

Delete the TicketsSubform label.

Save the form.

Switch to Form view. Verify that the border, Navigation bar, and label have been removed.

Add a calculated control onto the subform and enter an aggregate function.

Switch to Design view.

Click, hold, and drag the vertical scroll bar on the subform to move down to the Form Footer section.

Click the Form Footer section bar and set the Height property to $\mathrm{.}5".$

Add a text box control to the Form Footer section of the subform.

Enter $=$Sum$([$Fine$])$ into the Control Source property and SFTotalFine in the Name property.

Delete the label that was added with the text box.

Save the form.

Add a text box to the main form and reference a control from the subform.

Add a text box control below the subform and make the following changes to these properties: Enter $=[$TicketsSubform$].[$Form$]![$SFTotalFine$]$ into the Control Source property, $\mathrm{.}8"$ in the Width property, $3\mathrm{.}5"$ in the Top property, and $5\mathrm{.}4"$ in the Left property. Select Currency in the Format property, Transparent in the Border Style property, Bold in the Font Weight, and No in the Tab Stop property.

Click the label control of that text box and make the following changes to these properties: Enter Total cost of fines in the Caption property, $1\mathrm{.}2"$ in the Width property, $3\mathrm{.}5"$ in the Top property, and $4\mathrm{.}1"$ in the Left property. Select Bold in the Font Weight.

Save the form.

Enhance the look of the form.

Switch to Layout view.

Select all $16$ of the controls in the Details section

Layout view after selecting $16$ controls above the subform and one control in the header.

Press the right arrow key $25$ times to move the selected controls to the right.

Set the following property for the Form: Change the Scroll Bars property to Neither.

Save the form.