Saturday, December 28, 2019

The Subform Displays Control

Another approach allows you to forget about the way you design transitions to form and instead create a form containing everything you need. This tool, called a composite form, uses the Subform form control.


Talked about how the Slave form control allows you to display related data (such as a list of products in the current product category). But applying a subordinate form also makes sense to display several unrelated tables in one place. Just leave the properties of the subform Main fields and Subordinate fields blank - in this case the subform displays all records without filtering. In fig. 14.15 shows an example.

There is a method that speeds up the creation of a composite form. First, select Create> Forms> Form Designer on the ribbon to create an empty new form. Find the shape

which you want to use in a subordinate form, and drag it with the mouse from the transition area onto the working surface of your new form. Access will create a Subform form control in which this form is displayed. You can also drag the table onto your form, in which case Access will create a subform for the table (and ask you to choose a name for it).

No comments:

Post a Comment

The Garmin Venu Sq connected watch has it all

It is not always easy to combine the hectic daily life with a healthy lifestyle. Garmin has understood this well: the brand of connected wat...