Database Reference
In-Depth Information
Adjusting field widths is often easier in Layout view, where the underlying data from the table is
visible.
Let's test the subform.
15
Switch to
Form
view. Then use the record navigation bar for the main form to display
each category in turn, verifying that the products in that category are listed in the
datasheet in the subform.
8
16
Click the
First record
button to return to the first category (
Bulbs
). Then in the
subform, click
Bulbs
in the
Category
column to the right of the first product
(
Magic Lily
).
TIP
Because the Category field is a combo box control, an arrow appears at the right
end of the field to indicate that you can select a field value from a list.
17
Click the field's arrow to display the list of categories, and then change the category
to
Cacti
.