Microsoft Office Tutorials and References
In Depth Information
To finish creating the form:
1. Click the Next button. The next Form Wizard dialog box opens, in which you
choose the subform layout.
The Tabular layout displays subform fields as a table, whereas the Datasheet layout
displays subform fields as a table datasheet. The layout choice is a matter of per-
sonal preference. You’ll use the Datasheet layout.
2. Click the Datasheet option button (if necessary), and then click the Next button.
The next Form Wizard dialog box opens, in which you choose the form’s style
Oren wants all forms in the Belmont database to have the same style, so you will
choose Foundry, which is the same AutoFormat you applied to the Customer
3. Click Foundry (if necessary), and then click the Next button. The next Form Wizard
dialog box opens, in which you choose names for the main form and the subform.
You will use the name “Customer Contracts” for the main form and the name “Con-
tract Subform” for the subform.
4. Click the insertion point to the right of the last letter in the Form text box, press
the spacebar , and then type Contracts . The main form name is now Customer
Contracts. The Contract Subform name is already set.
5. Click the Finish button. After a few moments, the completed form opens in Form
view. Next, you’ll resize the columns in the subform to their best fit.
6. Double-click the pointer at the right edge of each column in the subform. The
columns are resized to their best fit. See Figure 4-18.
Main form with subform in Form view