Navigation Form: Subform Relationship Problem

[Jason1971]

Hi,
I have an Access 2010 (Web) Navigation Form containing 2 tabs. Tab1 contains Subform1, while Tab2 contains Subform2. I want subform2 to be related/influenced by subform1; so that a record shown/selected in subform1 results in the related records in subform2 to be shown. Like a parent/child relationship. Trouble is they are both subforms, so no partent/child arrangement exists. I am thinking that setting up the Navigation Where Clause will help but I've never used it before? Something like Forms![Subform1].[ID] = Forms![Subform2].[form1_ID]
Any help would be appreciated, thanks.
Jason.

 

[Galaxiom]

Try this:

Place a textbox (hidden if you wish) on the main form with the control source:
= Forms![Subform1].Form.[ID]
(Subform1 must be the subformcontrol name and you must include the Form property)

Then use this control as the Master Link Field of the second subform control.

 

[Jason1971]

Thank you for your help. Great idea. I have also switched from a Navigation Control to a Blank form containing your idea plus a Tab control. The Tab control seems to work better for my Subforms.
Thanks.