Synchronise 2 sub-forms (1 Viewer)

[h33]

Please see the attached zip.

I want to synchronise the data in the Sales subform so that, when a different record is clicked, the data in the subfrmSales2 changes.

IE, when a user clicks on OrderID1 in the Sales subform, then the data for OrderID1 shows in subfrmSales2. And when a user clicks on OrderID315 in the Sales subform, then the data for OrderID315 shows in subfrmSales2.

 

[ShaneMan]

Take a look at this post. The instructions giving should work for what your trying to do. Just change the names to the names of your controls.

HTH,
Shane

 

[h33]

Shane, what post are you refering to?

 

[ShaneMan]

Shane, what post are you refering to?

Sorry about that. I copied the link but forgot to post it. Here you go:

http://www.access-programmers.co.uk/forums/showthread.php?t=112326

HTH,
Shane