Subform

[Guest]

This might be an easy question (I'm new at this) but how can you make a
subform only show particular values based on a selection made in the main
form. For instance, you input on the main form the product type A and the
subform brings up all the information about the products you have that are
type A.

 

[Guest]

Two properties of the SubForm control on the main form are Link Master Fields
and Link Child Fields. These are used to link the record in the Main Form to
the records in the Sub Form. Put the name of the field from the record
source of the main form in the Link Master Fields property that related the
mater records to the child records and the name of the field in the record
source of the sub form that links the child records to the master records.

In your case, it is probably the field that carried the product type.

 

[John Vinson]

This might be an easy question (I'm new at this) but how can you make a
subform only show particular values based on a selection made in the main
form. For instance, you input on the main form the product type A and the
subform brings up all the information about the products you have that are
type A.

Set the Master Link Field of the Subform control to the name of the
control containing the product type on the mainform, and its Child
Link Field to the Type field in the subform's recordsource.

John W. Vinson[MVP]