Subform from query shows all records not just related records

  • Thread starter Thread starter Jojo
  • Start date Start date
J

Jojo

My database has two tables - Family and Children which are related showing
many children for one family.
I created a query to calculate School Year from each child's age.
I made a Family form with a Children subform which shows only the children
from the family whose record is open.
I want to include the information from School Year, but however I try to do
it it always shows the information about all children, not just the children
from that family.
I have the same problem when I try to do a Family report with a Children
subreport.
Help!
 
The LinkMasterFields/LinkChildFields properties are not set up correctly.

1. Open the form in design view.

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

3. Set the Master Link Fields property to the name of the field in the main
form (e.g. FamilyID), and the LinkChildFields property to the name of the
matching field in the subform (which might be something like FamilyID too.)
 
Back
Top