Which Of The Following Data Fields Cannot Be Found In The Patient Window?

When you are working with relational information (related data that is stored in split tables), you ofttimes need to view multiple tables or queries on the same form. For example, you might want to see client data from one tabular array and information about customer orders from another table at the same fourth dimension. Subforms are a user-friendly tool for doing this, and Access provides several ways to assist you create subforms chop-chop.

What practise yous want to do?

Acquire about subforms
Create or add a subform
Create a form that contains a subform by using the Class Sorcerer
Add one or more subforms to an existing class by using the SubForm Sorcerer
Create a subform by dragging one form onto another
Open up a subform in a new window in Pattern view
Change the default view of a subform
Add related information to a class without creating a subform

Learn virtually subforms

A subform is a grade that is inserted in another form. The primary grade is called the main course, and the class that is enclosed in course is called the subform. A form/subform combination is sometimes referred to every bit a hierarchical form, a master/item form, or a parent/child form.

Subforms are especially effective when you want to evidence data from tables or queries that take a one-to-many relationship. A one-to-many relationship is an association between two tables in which the main fundamental value of each tape in the primary table corresponds to the value in the matching field or fields of many records in the related table. For example, y'all can create a course that displays employee data, and contains a subform that displays each employee's orders. The information in the Employees table is the "one" side of the relationship. The data in the Orders table is the "many" side of the relationship — each employee can have more than ane order.

A form that contains a subform

1. The principal form shows data from the "i" side of the human relationship.

two. The subform shows data from the "many" side of the relationship.

The primary class and subform in this kind of grade are linked then that the subform displays only records that are related to the current record in the main form. For example, when the main form displays Nancy Freehafer'due south information, the subform displays only her orders. If the form and subform were unlinked, the subform would display all the orders, non just Nancy's.

The following table defines some of the terminology that is associated with subforms. Access will handle most of the details if yous use the procedures in this article, but it is helpful to know what is occurring behind the scenes if y'all demand to make modifications later.

Term	Definition
Subform control	The command that embeds a form into a course. You can retrieve of the subform control as a "view" of another object in your database, whether it is some other form, a table, or a query. The subform control provides properties which allow yous to link the data displayed in the control to the data on the main form.
Source Object property	The holding of the subform command that determines what object is displayed in the control.
Datasheet	A unproblematic display of data in rows and columns, much like a spreadsheet. The subform command displays a datasheet when its source object is a table or query, or when its source object is a form whose Default View holding is set to Datasheet. In these cases, the subform is sometimes referred to every bit a datasheet or subdatasheet instead of every bit a subform.
Link Child Fields belongings	The belongings of the subform command that specifies which field or fields in the subform link the subform to the main form.
Link Chief Fields holding	The property of the subform control that specifies which field or fields on the master course link the principal form to the subform.

Notes:

For best results, found table relationships earlier following the procedures in this article. This enables Access to automatically create the links betwixt subforms and main forms. To view, add together, or modify relationships between the tables in your database, on the Database Tools tab, in the Show/Hide group, click Relationships.
When a subform command has a form as its source object, it contains the fields that you place on the form, and it can be viewed as a unmarried course, continuous form, or datasheet. One advantage of basing a subform on a form object is that you tin add calculated fields to the subform, such as [Quantity] * [Unit of measurement price].
Yous can insert a datasheet or pivot view into a class by creating a subform control whose source object is a table or query. For more than information, see the section Add together related data to a class without creating a subform.

Top of Page

Create or add a subform

Use the post-obit table to determine which process is about advisable for your state of affairs.

Scenario	Recommended procedure
You lot want Admission to create both a main class and a subform, and to link the subform to the main grade.	Create a course that contains a subform past using the Form Wizard
You want to utilise an existing class as the main class, but yous want Access to create a new subform and add it to the master form.	Add ane or more subforms to an existing form by using the Subform Wizard
You lot want to use an existing form as the chief form, and you desire to add one or more existing forms to that form as subforms.	Create a subform past dragging one form onto some other

Create a form that contains a subform past using the Form Sorcerer

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 primary form or the subform.

On the Create tab, in the Forms group, click Form Magician.
On the starting time page of the wizard, in the Tables/Queries drop-down list, select a table or query. For this instance, to create an Employees grade that displays orders for each employee in a subform, we will select Table: Employees (the "1" side of the 1-to-many relationship).

Note:It does not matter which table or query you choose first.
Double-click the fields that you desire to include from this tabular array or query.
On the same page of the wizard, in the Tables/Queries driblet-downwards list, select another table or query from the listing. For this example, we will select the Orders table (the "many" side of the one-to-many relationship).
Double-click the fields that you lot want to include from this table or query.
When you click Next, bold that you set up up the relationships correctly before you started the wizard, the wizard asks How do you lot want to view your data? — that is, by which table or query. Select the table on the "one" side of the ane-to-many relationship. For this example, to create the Employees form, nosotros volition click by Employees. The wizard displays a small diagram of a class. The page should resemble the following illustration:

The box in the lower portion of the form diagram represents the subform.

Notation:If the wizard does non ask How do you want to view your data?, that means that Access did not notice a one-to-many relationship betwixt the tables or queries that yous selected. The wizard will continue, merely Access will not add a subform to the form. You lot might want to click Cancel and examine your tabular array relationships earlier you continue.
At the lesser of the wizard page, select Grade with subform(s), and and so click Next.
On the What layout would yous like for your subform? page, click the layout option that you lot want, and then click Next. Both layout styles accommodate the subform data in rows and columns, but a tabular layout is more customizable. You can add together color, graphics, and other formatting elements to a tabular subform, whereas a datasheet is more compact, like the datasheet view of a table.
On the next page of the wizard, select a formatting style for the class, and then click Next. If y'all chose Tabular on the previous page, the formatting mode yous choose will too be applied to the subform.
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 blazon for the subform.
Specify whether you want to open up the form in Form view, so that yous can view or enter information, or in Design view, then that yous can modify its design, and then click Finish.

Admission creates 2 forms — one for the principal form that contains the subform control, and one for the subform itself.

Acme of Page

Add one or more subforms to an existing form by using the SubForm Wizard

Use this process to add one or more than subforms to an existing form. For each subform, you can choose to have Access create a new form or use an existing course every bit the subform.

Right-click the existing form in the Navigation Pane, and and then click Design View.
On the Design tab, in the Controls group, click the down-arrow to display the Controls gallery, and ensure that Use Control Wizards is selected.
On the Design tab, in the Controls group, click the Subform/Subreport button.
Click on the course where you desire to place the subform.
Follow the directions in the wizard.

When y'all click Finish, Access adds a subform control to your class. If you chose to have Admission create a new grade for the subform instead of using an existing grade, Access creates the new form object and adds it to the Navigation Pane.

Create a subform by dragging 1 form onto another

Use this procedure if yous desire to employ an existing form equally a main form, and you want to add together one or more than existing forms to that form equally subforms.

In the Navigation Pane, right-click the class that you want to use as the main course, and then click Layout View.
Drag the grade that you want to apply as the subform from the Navigation Pane onto the main course.

Access adds a subform control to the main form and binds the control to the grade that yous dragged from the Navigation Pane. Access also tries to link the subform to the main grade, based on the relationships that have been defined in your database.
Repeat this pace to add any additional subforms to the principal class.
To verify that the linking was successful, on the Dwelling house tab, in the Views group, click View, click Form View, and and then use the main grade'south record selector to advance through several records. If the subform filters itself correctly for each employee, then the procedure is consummate.

If the previous test does not work, Access was unable to determine how to link the subform to the main form, and the Link Kid Fields and Link Master Fields properties of the subform control are bare. You must prepare these properties manually by doing the following:

Right-click the main form in the Navigation Pane, and then click Design View.
Click the subform command one time to select it.
If the Property Sail task pane is not displayed, press F4 to display information technology.
In the Holding Canvass, click the Information tab.
Click the Build push button next to the Link Kid Fields property box.

The Subform Field Linker dialog box appears.
In the Master Fields and Child Fields drop-downward lists, select the fields that you lot want to link the forms with, and so click OK. If you lot are not certain which fields to use, click Suggest to have Access try to determine the linking fields.

Tip:If you lot practice not see the field that you lot desire to use to link the forms, you might need to edit the record source of the principal form or child form to help make sure that the linking field is in it. For example, if the form is based on a query, you lot should make sure that the linking field is nowadays in the query results.
Save the chief form, switch to Grade view, then verify that the form works as expected.

Open up a subform in a new window in Pattern view

If y'all want to make design changes to a subform while yous are working on its principal form in Blueprint view, you can open the subform in its own window:

Click the subform to select it.
On the Design tab, in the Tools group, click Subform in New Window.

Top of Page

Change the default view of a subform

When you add together a subform to a form, the subform/subreport control displays the subform according to the subform's Default View holding. This property can be prepare to the following values:

Single Form
Continuous Forms
Datasheet
Divide Form

When you lot first create a subform, this belongings may exist set to Continuous Forms or perhaps Single Form. However, if you prepare the Default View property of a subform to Datasheet, and so the subform volition display as a datasheet on the main form.

To fix the Default View property of a subform:

Close whatever open objects.
In the Navigation Pane, right-click the subform and so click Design View.
If the Holding Sheet is not already displayed, printing F4 to display information technology.
In the driblet-down listing at the pinnacle of the Holding Sheet, brand certain Grade is selected.
On the Format tab of the Property Sheet, set up the Default View property to the view you want to employ.

Note:If the view you want to use is non in the list, brand sure the "Let…View" property for the view is fix to Yeah. For example, if y'all want to specify Datasheet as the default view for the form, brand sure that the Allow Datasheet View property is set to Yeah.
Save and close the subform, so open the main grade to check the results.