Doubleclick field to display query results

[mcreary]

Hi, can anyone tell me how to doubleclick on field (on a form) and it opens up a form that shows bounded filtered results. I have a sub form which has details supporting summary numbers. I want my user to doubleclcik on the currency field and the detail supporting that sum total, pops up automatically. Any help please?

 

[neileg]

There's a double click event. Use code in that event to load your detail form.

 

[Bee]

Hi, can anyone tell me how to doubleclick on field (on a form) and it opens up a form that shows bounded filtered results. I have a sub form which has details supporting summary numbers. I want my user to doubleclcik on the currency field and the detail supporting that sum total, pops up automatically. Any help please?

Go to properties of that field and you will find it. You will need to write VB code to get to do what you want though.