Microsoft Office Tutorials and References
In Depth Information
Lucia’s design for the custom form
Figure 6-19
combo
boxes
calculated
controls
subform
Notice that the top of the form displays a title and a combo box to select a contract
record. Below these items are six field values with identifying labels from the tblContract
table; these fields are the ContractNum, ContractAmt, SigningDate, StartDate, CustomerID,
and ContractType fields. The CustomerID field is displayed in a combo box and the other
field values are displayed in text boxes. The tblInvoice table fields appear in a subform, a
separate form contained within another form. Unlike the tblContract table data, which dis-
plays identifying labels to the left of the field values in text boxes, the tblInvoice table data is
displayed in datasheet format with identifying column headings above the field values.
Finally, Number of Invoices and Invoice Amount Total in the main form display calculated
controls based on the content of the subform.
Creating a Custom Form in Design View
To create Lucia’s custom form, you could use the Form Wizard to create a basic version
of the form and then customize it in Layout and Design views. However, to create Lucia’s
form, you would need to make many modifications to a basic form created by a wizard,
so you will create the form directly in Design view. Creating forms in Design view is easy
once you’ve done one form, and Design view allows you more control, precision, and
options than creating forms in Layout view. You’ll also find that you’ll create forms more
productively if you switch between Design view and Layout view, because some design
modifications are easier to make in one of the two views than in the other view.
The Form Window in Design View
You use the Form window in Design view to create and modify forms. To create the cus-
tom form based on Lucia’s design, you’ll create a blank form, add the fields from the
tblContract and tblInvoice tables, and then add other controls and make other form
modifications.
 
Search JabSto ::




Custom Search