Microsoft Access 2010 Bible

Part I: Access Building Blocks

262

FIGURE 7.11

Create a split form when you want to select records from a list and edit them in a form. Use the splitter bar
to resize the upper and lower sections of the form.

Form area

Datasheet area Splitter bar

Datasheet forms

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

create a form that looks like a table or query’s datasheet. A datasheet form is useful when you want

to see the data in a row and column format, but you want to limit which fields are displayed and

editable.

To create a datasheet 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 Form group’s More Forms button and click Datasheet.

You can view any form you create as a datasheet by selecting Datasheet View from the
ribbon’s View drop-down. A datasheet form appears in Datasheet View by default when
you open it.

Tip
You can prevent users from viewing a form as a datasheet by setting the form’s properties. You’ll learn more
about form properties in the “Introducing Properties” section, later in this chapter.