Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Grab select on Right Mouse button

Discussion in 'Information Technology' started by Vic Spainhower, Nov 6, 2005.

  1. Vic Spainhower

    Vic Spainhower
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    India Mumbai Land Grab Breaking News Dec 8, 2012
    USA US Has Snatch and Grab Plan for PAK Nukes Breaking News Aug 6, 2011
    Sir Mota Singh grabs 'Pride of Sikh Community' award Sikh Personalities May 3, 2010
    Sikh News Pak Army grabs Sikh Gurudwara land Breaking News Dec 18, 2009
    Sikh News Punjab rushes to grab Nano chance, offers 1,000 acres (Express India) Breaking News Aug 23, 2008

  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    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" <vicNoSpam@perfected.com> 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
    >
    >
    >
     
  4. Vic Spainhower

    Vic Spainhower
    Expand Collapse
    Guest

    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" <VanThien.Dinh@discussions.microsoft.com> 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" <vicNoSpam@perfected.com> 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
    >>
    >>
    >>

    >
    >
     
  5. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

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

    --
    HTH
    Van T. Dinh
    MVP (Access)




    "Vic Spainhower" <vicNoSpam@perfected.com> 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
    > Form_Current Event!
    >
    > Vic
    >
    >
     

Share This Page