Learn how to create a form in Access that contains a subform (also known as a one-to-many form, a parent/child form, or a hierarchical form).

You can do this in Access by linking the multiple-item form to a single-item form. When you click an item in the multiple-item form, the single-item form opens to show the details.

When you are working with related data that is stored in separate tables, you often need to view data from multiple tables or queries on the same form and subforms are a convenient way to …

When you create a subform or subreport by using a wizard or by dragging an object from the Navigation Pane to a report, Access automatically links the subform or subreport to the main …

You have a main form that contains a subform; the subform contains a calculated text box (for example, a total of item prices), the results of which you want to display on the main form.

To prevent the OpenForm action from overriding any of these existing property settings, omit the Data Mode argument setting so that Access will use the property settings defined by the form.

You can use a query to supply data to a form or report in Access. You can use a query when you create the form or report, or you can change an existing form or report by setting its Record …

When two tables in Access have one or more fields in common, you can embed the datasheet from one table in another. An embedded datasheet, which is called a subdatasheet, is useful …

You can use calculated controls on forms and reports in Access databases to display the results of a calculation. For example, if you have a report that displays the number of items sold and …

Adding tabs to an Access form can make it more organized and easier to use, especially if the form contains many controls. By placing related controls on separate pages of the tab control, …