When a subform control has a form as its source object, it contains the fields that you place on the form, and it can be viewed as a single form, continuous form, or datasheet. To view, add, or modify relationships between the tables in your database, on the Database Tools tab, in the Show/Hide group, click Relationships. This enables Access to automatically create the links between subforms and main forms. The property of the subform control that specifies which field or fields on the main form link the main form to the subform.įor best results, establish table relationships before following the procedures in this article. The property of the subform control that specifies which field or fields in the subform link the subform to the main form. In these cases, the subform is sometimes referred to as a datasheet or subdatasheet instead of as a subform.
The subform control displays a datasheet when its source object is a table or query, or when its source object is a form whose Default View property is set to Datasheet. The property of the subform control that determines what object is displayed in the control.Ī simple display of data in rows and columns, much like a spreadsheet. The subform control provides properties which allow you to link the data displayed in the control to the data on the main form. You can think of the subform control as a "view" of another object in your database, whether it is another form, a table, or a query. The control that embeds a form into a form. Access will handle most of the details if you use the procedures in this article, but it is helpful to know what is occurring behind the scenes if you need to make modifications later. The following table defines some of the terminology that is associated with subforms. If the form and subform were unlinked, the subform would display all the orders, not just Nancy's. For example, when the main form displays Nancy Freehafer's information, the subform displays only her orders. The main form and subform in this kind of form are linked so that the subform displays only records that are related to the current record in the main form. The subform shows data from the "many" side of the relationship.
The main form shows data from 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 one order.ġ. The data in the Employees table is the "one" side of the relationship. For example, you can create a form that displays employee data, and contains a subform that displays each employee's orders. A one-to-many relationship is an association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table. Subforms are especially effective when you want to show data from tables or queries that have a one-to-many relationship. A form/subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form. The primary form is called the main form, and the form that is enclosed in form is called the subform.
Open a subform in a new window in Design viewĪdd related data to a form without creating a subformĪ subform is a form that is inserted in another form. What do you want to do?Ĭreate a form that contains a subform by using the Form WizardĪdd one or more subforms to an existing form by using the SubForm WizardĬreate a subform by dragging one form onto another Subforms are a convenient tool for doing this, and Access provides several ways to help you create subforms quickly.
For example, you might want to see customer data from one table and information about customer orders from another table at the same time. Lists Unordered Lists Ordered Lists Other Lists HTML Block & Inline HTML Classes HTML Id HTML Iframes HTML JavaScript HTML File Paths HTML Head HTML Layout HTML Responsive HTML Computercode HTML Semantics HTML Style Guide HTML Entities HTML Symbols HTML Emojis HTML Charset HTML URL Encode HTML vs.When you are working with relational data (related data that is stored in separate tables), you often need to view multiple tables or queries on the same form.
0 kommentar(er)
