Pivot table, link data to a form

[guinness]

Hi all

Haven't been here for a while so I hope I'm still welcome. I'm looking for help with something I'm sure is basic but I can't get to work. I have a pivot table form that shows a summary of peoples activities for the week. The table summarises data from another more detailed form. What I'd like to do is create a link so that if you clicked on team members name from within the pivot table it would take you to the detailed form that the pivot is based on and display that persons record.

I hope that makes sense.

Cheers

 

[mistera]

Did you ever find a way to do this? I have a similar situation in that I have a sub-form that is a pivot table and I want to change info displayed in the main form based on the user "selecting" or clicking a cell in the pivot table.

Basically, all I need is to capture the row/column info from the pivot table at the intersection that is clicked/selected in the detail data section.