Microsoft® Office Access™ 2007 Plain & Simple

Displaying a Form and Its Datasheet Simultaneously

Subforms enable you to display the data from two related tables or queries in a single form. What they don’t enable you to do, however, is display the entire datasheet from which the form draws its data. If you create a subform that displays the same data as the main form, it only displays the current record, not the entire datasheet.

Create a Split Form

1. Click the table to serve as the source of your form data.

2. Click the Create tab.

3. Click Split Form.