pulling data into a subform

[hkinh_nguyen]

Can anyone pull data into a subform when click on a list that is on another subform. Another words, I have two subform on the same form. On one subform I have a list of names; by clicking on the list of names, I want to chose a name and have more detailed info appear on the second subform. Please Help

 

[llkhoutx]

The name field of the first subform is the

Link Master Field property of the 2nd subform.

The corresponding name field of the second subform is the

Link Child Field property of the 2nd subform.

You'll may have to requery the 2nd subform on the first subform OnCurrent event and on field of the first subform AfterUpdate event. The subform will them tumble to the correct record on each of these events.