How+to+Create+a+Form+that+Contains+a+Subform

=__How to Create a Form that Contains a Subform__ = = =  **While completing the Access homework assignment, I had a difficult time understanding how to create a subform using the Form Wizard. I found these step by step instructions, provided by** [|Microsoft]**, that explained exactly how to create a subform.**

Create a form that contains a subform by using the Form Wizard
This procedure creates a new form and subform combination by using the Form Wizard. This is also the quickest way to get started if you have not already created the forms that you want to use as the main form or the subform. If the wizard does not start This could be due to the fact that Access is running in sandbox mode but Microsoft Jet 4.0 SP8 or later is not installed on your computer. Jet 4.0 SP8 or later is required for Access to be fully functional when sandbox mode is enabled. For more information about installing the Jet upgrade, see the Office Online article //About Microsoft Jet 4.0 SP8 or later//. For more information about sandbox mode, see the Office Online article //About Microsoft Jet Expression Service sandbox mode//.
 * 1) On the **Create** tab, in the **Forms** group, click **More Forms**, and then click **Form Wizard** [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA101790281033 caption="Button image"]].

Access creates two forms — one for the main form that contains the subform control, and one for the subform itself.
 * 1) On the first page of the wizard, in the **Tables/Queries** drop-down list, select a table or query. For this example, to create an Employees form that displays orders for each employee in a subform, we will select **Table: Employees** (the "one" side of the one-to-many relationship).
 * Note** It does not matter which table or query you choose first.
 * 1) Double-click the fields that you want to include from this table or query.
 * 2) On the same page of the wizard, in the **Tables/Queries** drop-down list, select another table or query from the list. For this example, we will select the Orders table (the "many" side of the one-to-many relationship).
 * 3) Double-click the fields that you want to include from this table or query.
 * 4) When you click **Next**, assuming that you set up the relationships correctly before you started the wizard, the wizard asks **How do you want to view your data?** — that is, by which table or query. Select the table on the "one" side of the one-to-many relationship. For this example, to create the Employees form, we will click **by Employees**. The wizard displays a small diagram of a form. The page should resemble the following illustration: [[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA102789871033 caption="The subform page of the Form Wizard"]][[image:http://office.microsoft.com/global/images/default.aspx?AssetID=ZA010939481033 caption="Callout 1"]] The box in the lower portion of the form diagram represents the subform.
 * Note** If the wizard does not ask **How do you want to view your data?**, that means that Access did not detect a one-to-many relationship between the tables or queries that you selected. The wizard will continue, but Access will not add a subform to the form. You might want to click **Cancel** and examine your table relationships before you continue. Find links to more information about relationships in the **See Also** section.
 * 1) At the bottom of the wizard page, select **Form with subform(s)**, and then click **Next**.
 * 2) On the **What layout would you like for your subform?** page, click the layout option that you want, and then click **Next**. Both layout styles arrange the subform data in rows and columns, but a tabular layout is more customizable. You can add color, graphics, and other formatting elements to a tabular subform, whereas a datasheet is more compact, like the datasheet view of a table.
 * 3) On the next page of the wizard, select a formatting style for the form, and then click **Next**. If you chose **Tabular** on the previous page, the formatting style you choose will also be applied to the subform.
 * 4) On the last page of the wizard, type the titles that you want for the forms. Access names the forms based on the titles that you type, and labels the subform based on the title that you type for the subform.
 * 5) Specify whether you want to open the form in Form view, so that you can view or enter information, or in Design view, so that you can modify its design, and then click **Finish.**

[]