I am creating a Database of Geneology and has only one table (PersonTbl) with the following fields:
PersonID (Primary Key), FirstName, LastName, DOB, MotherID, FatherID
Both the Mother & Father are also in the table & their ID is the PersonID
The Main form contains the fields from the table & the Mother & Father ID are Combo Boxes
The form contains a subform in which children data are entered. This Subform is having the crieteria from a query:
SELECT PersonTbl.*
FROM PersonTbl
WHERE (((PersonTbl.MotherID)=[Forms]![PersonFrm]![PersonID])) OR (((PersonTbl.FatherID)=[Forms]![PersonFrm]![PersonID]));
What I want is when the Mother or Father combo boxes are double clicked, the Form should requery with their data.
Thanks