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.
Click the table to serve as the source of your form data.
Click the Create tab.
Click Split Form.