Pivot table form - on click

[danielc]

Hi,

I have a form with a subform set for pivot table view. I want to go to a specific record in main form based on the selection I made on the pivot table subform. Something like on click (select) for pivot table view.
It should be possible but I can't figure how.

thank you for your help.

Daniel