Linking fields over two subforms, double click

[steve1111]

I have seen post on how to double click an ID in a query an open up the form with that record, but i was looking at how to do that when the form is inside a subform.

I have a form [Managers Log Nav] that has two subforms on it. the left is mlogentryctrl (which is a place a new record can be entered) and the right subform is mlogctrl (the place where the query is stored).

How can i double click on the ID in the query and have the record load into the form on the left subform.

i have some but minimal VBA experience.

thanks