Referring to main form when focus is in its subform?

[PierreR]

I have two tables. A table called tblPeople, many-to-many self-joined through the other table called tblPeopleJoin. That means there are two joins between tblPeople and tblPeopleJoin.

The two joins are 1) from PeopleID and 2) from PeepleID in tblPeopleJoin on PeopleID in tblPeople and Referential Integrity is checked for both.

I've made a single-view form based on tblPeople, and its continuous subform is based on tblPeopleJoin. They are master-child connected through PeopleID of tblPeopleJoin. PeepleID is converted to a combo, row-sourced on tblPeople.

This way I can relate people to each other. (another table for relationshiptypes is linked to tblPeopleJoin, and that also shows as a combo, but that is not important in my question here)

So when the main form is open it shows the detail about the person, and a list of all his/her relationships, with person and relationship type. What I want to do is to click on a button in the subform to go to the record in the main form of the person that is in focus on the subform.

SO, THE QUESTION IS: HOW DO I REFER TO THE MAIN FORM WHEN THE FOCUS IS IN ITS SUBFORM?

I think I can do it with that information.

Pierre.

 

[dcx693]

Have you checked the FAQ section? Syntax for Main and Subforms

 

[PierreR]

Thank you dcx693. It is beautiful.

Me.Parent!

And thank you SJ (Mile O Phile) for a great job.