06-Nov-2005, 12:37 PM
|  | Guest | | | | | | | | | | Re: Grab select on Right Mouse button
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 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6783Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6783
the newly re-ordered Recordset of the Form.
--
HTH
Van T. Dinh
MVP (Access)
"Vic Spainhower" wrote in message
news:%23g3Csfk4FHA.3636@TK2MSFTNGP09.phx.gbl...
> 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
>
>
>
|
06-Nov-2005, 12:37 PM
| | Guest | | | | | | | | | | Re: Grab select on Right Mouse button
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 Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6783
"Van T. Dinh" wrote in message
news:uvfSMYl4FHA.1416@TK2MSFTNGP09.phx.gbl...
> 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.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
>
> "Vic Spainhower" wrote in message
> news:%23g3Csfk4FHA.3636@TK2MSFTNGP09.phx.gbl...
>> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6783
>> someone help?
>>
>> Thanks,
>>
>> Vic
>>
>>
>>
>
>
 |
07-Nov-2005, 11:26 AM
| | Guest | | | | | | | | | | Re: Grab select on Right Mouse button
I am not sure but have you tried Screen.ActiveControl? Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6783
--
HTH
Van T. Dinh
MVP (Access)
"Vic Spainhower" wrote in message
news:eFwlbnm4FHA.2552@TK2MSFTNGP10.phx.gbl...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6783
> Form_Current Event!
>
> Vic
>
>
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
