[AccessD] link subform to subform

That's it. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Saturday, December 23, 2006 9:11 AM
To: Access Developers discussion and problem solving
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com