Fire Event When Click on Total Row (1 Viewer)

D

Djblois

Registered User.

Local time

Today, 02:24

Joined

Jan 26, 2009

Messages

598

• Jul 23, 2019

• #1

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?

 

Last edited: Jul 23, 2019

Ranman256

Well-known member

Local time

Today, 05:24

Joined

Apr 9, 2015

Messages

4,337

• Jul 23, 2019

• #2

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

 

D

Djblois

Registered User.

Local time

Today, 02:24

Joined

Jan 26, 2009

Messages

598

• Jul 23, 2019

• #3

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

 

theDBguy

I’m here to help

Staff member

Local time

Today, 02:24

Joined

Oct 29, 2018

Messages

21,467

• Jul 23, 2019

• #4

Djblois said:

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

Click to expand...

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.