Subform from query shows all records not just related records

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!
 
A

Allen Browne

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"referrer" entries in an alaphabetic list 1
Report does not contain all the records I expect 1
Query for Subform Needed Please 4
Retrieving data from multiple records 2
My report contains multiple copies of each record 2
Query with 3 tables with 1 to many relationship 7
Confusing Query (Flat File Query/Report from Relational DB) 1
Record not showing if no record in many table 1

Top