Microsoft Office Tutorials and References
In Depth Information
Using a Subform to Display Detail Records
3. To adjust the properties of the form, display the property sheet (if it’s
not already visible) by clicking the Property Sheet button in the Tools
group on the Design tab of the Ribbon.
Make sure that the Selection Type menu is set to Form so that you see
the properties of the whole form.
4. Click the Format tab of the property sheet, and scroll down to the Split
Form properties.
The properties that control split forms are listed in Table 4-1.
Table 4-1
Properties of Split Forms
Split Form
Specifies the height (usually, in inches) of the part of the
form that is not occupied by the datasheet. The default
setting is Auto , which tells Access to use a height that
displays the whole form.
Split Form
Specifies where the datasheet appears on the form:
Left , Right , Top , or Bottom . Bottom is the
Split Form
Splitter Bar
Specifies whether a splitter bar appears in Form view.
The user can drag the splitter bar up and down to
change how much of the form appears.
Specifies what the user can do in the datasheet:
Allow Edits or Read Only .
Split Form
Split Form
Specifies what is printed if you print the form: Form
Only or Datasheet Only .
Using a Subform to Display Detail Records
Sometimes, you need to display information from two different tables or
queries on the same form. For an online store, if you have a form that shows
information about one order from your Orders table, it would be nice if you
could also see a list of the items that were included in the order, which may
be stored in the related Order Details table.
Book IV
Chapter 4
Figure 4-4 shows an example. The main part of the form displays records
from the “one” side of a one-to-many relationship — the Orders table — and
the subform displays records from the “many” side — the Order Details
table. As a result, the subform displays many records that relate to the “one”
record on the main form.
Search JabSto ::

Custom Search