How do you sync subforms?

[nathanstevenson]

Hello all,

How do you sync a subform based on the same key? eg. link
subform A to mainform by primary key. THen link subform B to subform A, by subform A's foreign key and subform B's primary key?

It should be very simple, but it is doing my head in!

Thanks,
Nathan

 

[markuslutz]

try this:

- create in the mainform a unbound editfield i.e. editDummyID
- in SubFormA's Form_Current() add
Me.Parent.editDummyID.Value = Me.foreignkeyXYZ
- link SubFormB to editDummyID

another solution is to set the control source of the dummyfield to the subformA's foreign key. When I used this I had refresh problems (subforms began flickering)...

hope this helps