Sub-Forms NOT. Main form with two subforms, want to link

[bill]

Access is good about linking a SUB-FORM to a MAIN form

But, looking for code to sync to subforms on a main form.

The main form is only a holder, not bound, no data, etc...

Have done research on:
LinkChildFields
LinkMasterFields

but have found nothing meaningful.

Thanks!

 

[Dugantrain]

Re: Sub-Forms NOT. Main form with two subforms, want to lin

What is the relationship between these two subforms? Like a Master-Child sort of thing or are they even related at all? The way that I do two Master-child subforms on a main "container" form is:
-Place both subforms where you like
-In the Child's Recordsource, select all of the fields that you'll want to see and in the Criteria of its Foreign Key, write:

Forms!Your_Main_Container_Form!Your_Parent_Subform.form!Your_Parent_Subform_Primary_Key

-And then, to get the Child to display the related records for each Parent record, in the Parent's On_Current event:

Your_Parent_Subform_On_Current()
forms!Your_Main_Container_Form!Your_Child_Subform.Requery
End Sub

Is this what you're looking for or did I miss your point completely?