show correlating data

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Good evening!

I have a Client form [frmClient] that has a subform
[subformFamily]. While at client "Bob", the user enters
all of Bob's family members at [subformFamily] - the
family members are other clients; the primary care giver
in the family is indicated by a check box. So if Bob is
the primary family member, then I use the subform to
enter "Jane" as sister and "Mary" as wife.

How then do I get the family list to show up as a listbox
on "Jane" and "Mary". The data is linked by a master
table of FamilyID, so I just need something to say "show
me all members with the same familyID as the person on
the screen?

Sorry...its probably simple but I'm stumped ;-)

Denise
 
If I got you right, what you are looking for is something
like settin the listbox rowsource to a query of type

SELECT * FROM clientTable
WHERE (clientTable.failyID = frmClient.familyID);

and then requerying the listbox. Oh, and if that is what
you need, you might want to add column headers

HTH

Chris
 
Back
Top