D
DB
I have a main form with 2 subforms. The main form basically an individuals
name and minmal individual info.
One subform is a list of items belonging to the individual in the main
form.This form displays a couple fields - the item name and year in a
datasheet view. This form is linked to the main form.
The other subform is detailed info of the item in the other subform. What I
want to happen is when I look at the main form I want to see a list of items
belonging to the individual and be able to select from the item list and see
the detailed info to whatever item is clicked on.
All works well ie the main form is linked to the first subform and an item
list is displayed for each idividual record and the detailed info for the
first item in the list is displayed. But when I select on another item in the
list the detailed info does not change. In other words I need to link the
detailed subform to the list subform but I can not do this without messing up
the link between the main form and first subform.
Main form is master to first subform and first subform is master to
second(detailed info) subform. How can I complete the dual link or is there a
better way to accomplish this.
Thanks
DB
name and minmal individual info.
One subform is a list of items belonging to the individual in the main
form.This form displays a couple fields - the item name and year in a
datasheet view. This form is linked to the main form.
The other subform is detailed info of the item in the other subform. What I
want to happen is when I look at the main form I want to see a list of items
belonging to the individual and be able to select from the item list and see
the detailed info to whatever item is clicked on.
All works well ie the main form is linked to the first subform and an item
list is displayed for each idividual record and the detailed info for the
first item in the list is displayed. But when I select on another item in the
list the detailed info does not change. In other words I need to link the
detailed subform to the list subform but I can not do this without messing up
the link between the main form and first subform.
Main form is master to first subform and first subform is master to
second(detailed info) subform. How can I complete the dual link or is there a
better way to accomplish this.
Thanks
DB