![]() 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. I guess I could put one around the header section and another around the details section, but it makes it look horrible.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. I've tried setting a rectangle around my forms, but since I'm using form headers I can't put it around the whole form. So, I need a way to hide the form title bar while being able to set a thin border for the form to establish its bounds clearlier. ![]() I haven't found a way to hide it other than setting the form border to none, but that makes some small forms that popup on top of other forms (which I don't want to close when opening the other form because of crossed references and various visual reasons) merge with the form on the background and make it hardly distingishable. I have some pop-up forms which I want to show without title bar since I've designed custom placement functions and I don't want them to be moved or closed from the title bar, so having it show only makes the form look uglier. I'm pretty sure this must have been asked before but I can't seem to find a solution. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |