D
DavidWMeggett
I have form that we use to complete registrations for an educational program.
The tables I use are: tblprog2006 (key idsprogid), tblfamily (key
idsfamilyid), tblchild (key idschildid), tblcontact (key idscontactid). In
the registration form I have the main form as frmprog2006 with subform
counselor and subform volunteer as well as subform family. Within subform
family I have subforms child and contact.
the tables relations are as follows:
tblprog2006.idsprogid (one) ---> tblfamily.lngzprogid (many)
tblfamily.idsfamily (one) ---> tblchild.lngzfamilyid (many)
tblfamily.idsfamily (one) ---> tblcontact.lngzfamilyid (many)
Is it possible to use a combo box to filter the forms to find a child by
putting in their last name? If so how can I do it? If I cannot use a combo
box, how can I do it? Simplicity is appreciated.
The tables I use are: tblprog2006 (key idsprogid), tblfamily (key
idsfamilyid), tblchild (key idschildid), tblcontact (key idscontactid). In
the registration form I have the main form as frmprog2006 with subform
counselor and subform volunteer as well as subform family. Within subform
family I have subforms child and contact.
the tables relations are as follows:
tblprog2006.idsprogid (one) ---> tblfamily.lngzprogid (many)
tblfamily.idsfamily (one) ---> tblchild.lngzfamilyid (many)
tblfamily.idsfamily (one) ---> tblcontact.lngzfamilyid (many)
Is it possible to use a combo box to filter the forms to find a child by
putting in their last name? If so how can I do it? If I cannot use a combo
box, how can I do it? Simplicity is appreciated.