Sync multiple forms, different recordsets, not parent/child?

[NXMold]

I am building a complex interface, the main form is blank with two sub-forms. The recordset of each subform is linked via code on the main form.

Set Me.SubFrm2.Form.Recordset = Me.SubFrm1.Form.Recordset

In this way, when you select a record from SubFrm1 (list view) you can edit it in SubFrm2 (detailed view). I like this approach better than having so many popup forms, you don't get lost/disoriented in the application as easily.

Now for the problem:
I want to add a third sub form. This one has a different recordset, but I want it synced with the other two (the third form should display data realted to the selected record, and change as you scroll through records).

I know this relationship is possible with parent/child linked fields, but because of the way I constructed three sub-forms on a blank container form this relationship is not possible.

 

[MajP]

but because of the way I constructed three sub-forms on a blank container form this relationship is not possible.

No.Not a true statement. See how this is done.

http://www.4shared.com/get/97759751/2cc085c4/SubForms.html

 

[MajP]

Access does not make this clear and the Wizards tend to suggest that you need a parent child relationship. Actually the subform control is more powerful than that.

For example I can simply link a subform to an unbound text box or other control. If I type in the number 1 into that box I can show all records with a value of 1 in one of the fields. Normally that is a foreign key. Then any new records will get the value 1 in the linked field.

Subforms do not require a parent child relationship to link.

 

[NXMold]

Thats fantastic!!!! Thank you.

On before update of the 'list' sub form it sets the value of an unbound text box on the main form, the other sub forms are linked to that text box. Pretty snappy.