Subform display's all records/data...

[skp]

....from table. I only want it to display the
records/data that corresponds to the record displayed on
main form.
What am I missing or doing wrong?

thanks,
skp

 

[Allen Browne]

The LinkMasterFields/LinkChildFields properties determine which records are
loaded into the subform to match the record in the main form.

1. Open your main form in design view.

2. Right-click the edge of the subform control, and choose properties.

3. Locate the LinkMasterFields property (on the Data tab of the properties
box).

4. Set this to the name of the control on the main form that the subform
should match.

5. Set the LinkChildFields property to the name of the field in the subform
that should match.