Microsoft Access 2010 Bible

Chapter 7: Creating Basic Access Forms

261

Access creates a new multiple-items form based on tblProducts displayed in Layout
view (as shown in Figure 7.10). Although the form looks similar to a datasheet, you can
only resize the rows and columns in Design view and Layout view.

FIGURE 7.10

Create a multiple-items form when you want to see data similar to Datasheet view.

Split forms

Click the More Forms button in the ribbon’s Form group, and then click the Split Form button,

to create a split form based on a table or query selected in the Navigation Pane. The split-form fea-

ture gives you two views of the data at the same time, letting you select a record from a datasheet

in the upper section and edit the information in a form in the lower section.

To create a split form based on tblProducts, follow these steps:

1. Select tblProducts in the Navigation Pane.


2. Select the Create tab on the ribbon.


3. Click the More Forms button and click Split Form.

Access creates a new split form based on tblCustomers displayed in Layout view
(shown in Figure 7.11). Resize the form and use the splitter bar in the middle to make
the lower section completely visible.

The Split Form Orientation property determines whether the datasheet is on the top, bot-

tom, left, or right of the form area. The default is as shown in Figure 9-11, with the datasheet area

on the bottom. frmCustomers_SplitForm (shown in Figure 7.11) is included in the

Chapter07.accdb example database.