Grab select on Right Mouse button

[Vic Spainhower]

Hello,

When the user selects a sort option using the right mouse button I want to
grab this so that I can change the recordsource property for a subform. I
have not been able to come up with a way to do this. Can someone help?

Thanks,

Vic

 

[Van T. Dinh]

My guess is that you can use the Form_Current Event since most of the time,
the Current Record of the Form will change. The only exception occurs when
the existing Current Record (just before ordering) is the first Record in
the newly re-ordered Recordset of the Form.

 

[Vic Spainhower]

Van,

Thanks for the reply but I need to be able to see which column the user is
sorting on. I don't see how I would be able to determine this in the
Form_Current Event!

Vic

 

[Van T. Dinh]

I am not sure but have you tried Screen.ActiveControl?