[AccessD] Two levels up (or down) , twice removed

Thanks for the demo.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> I'll try to explain it more clearly. 
> 
> The topmost form is an unbound form - frmWrapper
> frmParent, frmChild and frmGrandchild are all subforms on frmWrapper.
> txtParentLink and txtChildLink are controls on frmWrapper.
> 
> The Source of txtParentLink is set to =frmParent!Form.PK
> The Source of txtChildLink is set to =frmChild!Form.PK
> 
> The Link Master Fields of frmChild is set to =txtParentLink
> The Link Master Fields of the frmGrandchild is set to =txtChildLink
> 
> Now change the current record in frmParent:
> txtParentLink automatically updates to the new Parent.PK
> frmChild automatically requeries based on the new content of txtParentLink (frmParent,PK)
> txtChildLink automatically updates to the new Child.PK.
> frmGrandchild automatically requeries based on the new content of txtChildLink(frmChild.PK)
> 
> It all happens without any on_current code.
> 
> I can put a simple demo up on-line if you like.