Form to Requery on double clicking a combo box

[Alex Motilal]

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

[Bob Fitz]

Have you tried something like the following in the OnDblClick event of the combo box:

Me.[NameOfSubFormControl].Requery