Fire Event When Click on Total Row

[Djblois]

I am using the Current Event to change the records in another subform as a user clicks on different records in the first subform. However, I want to make it so if the user clicks on the total row then it will show all the data on the other form. Is it possible to know when a user clicks on a total row?

 

[Ranman256]

that would be an ONCURRENT event. when the row changes, see if it is your Total Row.

 

[Djblois]

Ranman256, I understand it would be an oncurrent event but how do I determine it is a total row?

 

[theDBguy]

Ranman256, I understand it would be an oncurrent event but how do I determine it is a total row?

Hi. Pardon me for jumping in... I just gave it a try and it seems the Current event does not fire by going to the Totals row. Actually, I tried a few other events and none of them fired.