VBA to filter report records on double click of name

[isaacski]

Hi Everyone!,
I have a report that includes a list of names and some detail (scores) for each name. I would like to be able to double click on the name and have the report filter out only this name. For example,

John
Jenny
James <double click on James>

James

I'm hoping there is some simple VBA for the double click but I can't seem to find any of the pieces to build it...

Any help would really be appreciated!

Thanks, Kim

 

[carahorse]

I could use this too, would be great to view at a glance how many purchases a customer has please let me know if you get a solution

 

[mdlueck]

Hi Everyone!,
I have a report that includes a list of names and some detail (scores) for each name. I would like to be able to double click on the name and have the report filter out only this name.

Think of a report as a virtual piece of paper. This can not be done with paper alone.

What would be doable is to have a Multiple Items form listing the records, double click one record to open the report filtered for the specified name.