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

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

Click the Create tab.

Click Split Form.

[View full size image]