Microsoft Office Tutorials and References
In Depth Information
Using a Subform to Display Detail Records
Viewing the properties of subform controls
After you create the subform, you can edit it in either of two ways:
✦ Open the subform by right-clicking its name in the Navigation Pane and
choosing Design View from the contextual menu.
✦ Open the main form in Design view and double-click the subform control
to start editing the subform that appears in the control.
Either way, Access saves the changes to the subform separately from the
changes to the main form. When you save your main form, Access saves
changes to your subform, too.
While you’re fooling with the fields on the subform, you may want to change
the properties of the subform control that displays the subform on the main
form. To see the properties of the subform control, display the main form in
Design view, display the property sheet, and then click the subform.
Don’t click the gray box in the top-left corner of the subform. If you do, you
end up seeing the properties of the form that you’re using as a subform
rather than the properties of the subform control.
When you’re viewing the properties of the subform control, the Selection
Type drop-down menu at the top of the property sheet shows the name of
the subform control; if it doesn’t, choose the subform control name from the
Here are some useful entries that you can change on the Data tab of the
property sheet for the subform control:
✦ Source Object: The name of the form to display in this subform
✦ Link Child Fields: The field name in the record source of the
subform. This field must match the Link Master Fields field.
✦ Link Master Fields: The field name in the record source of the main
form. This field must match the Link Child Fields field.
Other properties have to be changed in the subform itself. Open the subform
in Design view, and display the property sheet for the form. Alternatively,
with the main form open in Design view, click the subform control to select
it and then click the gray box in the top-left corner of the subform to select
the form properties.
If you’re editing the properties of a subform in Design view of the main form,
click elsewhere on the main form to tell Access to update the subform
properties. Otherwise, your changes won’t appear to have taken effect when you
switch to Form view.