[AccessD] link subform to subform

> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Sad Der
> Sent: Saturday, December 23, 2006 4:47 AM
> To: Acces User Group
> Subject: [AccessD] link subform to subform
> 
> Hi group,
> 
> i've got a form with 2 subforms eg:
> Mainform = fParent
> Subform1 = fsubParent_Child
> Subform2 = fsubChild
> 
> 
> Subform1 links to mainform.
> Subform2 needs to link to subform1
> 
> Question:
> how can i link subform2 to subform1??

Create a text box txtLink on fParent.
Set its Visible property to False
Set it's ControlSource = 
fsubParent_Child.Form!txtKey
(where txtKey is a text box on fsubParent_child 
containing the PK of its record source.

Set the Link Parent Field of fsubChild = txtLink
and its Link Child Field to the FK of its own record source.



 -- 
Stuart