Entering data and updating forms mandating community service is bad
Although the technique may seem difficult, creating a subform is a snap, as we'll show you in this article. Once you master this simple technique, you may find yourself redesigning all your forms.
Creating the forms Creating a supplier subform Using the form and subform Creating a product subform Variations The best way to show you how to create subforms is by demonstrating the process with an example. The tables must include a common field that you can use to link them.
Only those records that match both criteria should be displayed in the form.
Fortunately, you don't have to go to this trouble, because Access lets you place forms for multiple tables on a single form.
In any multitable Access form, you have a main form and one or more subforms.
The table's fields must be the same field type and length, although they don't necessarily need to have the same name.
For our example, we'll use the Products and Suppliers tables shown in Figure B.