Welcome to SPN

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

Sign Up Now!

Auto Selecting Sub Data Sheets

Discussion in 'Information Technology' started by aheath15, Jul 28, 2006.

  1. aheath15

    aheath15
    Expand Collapse
    Guest

    My Situation:

    I have a list of products, some of which contain sub-assemblies, which are
    then listed in sub-data sheets. For ordering purporses, a user can go down
    the table and select which products are needed (using a boolean field).
    Since some products contain sub-assemblies, I am trying to figure out the
    best way to have these sub-assembly components automatically selected to
    prevent the user from forgetting to order necessary products.

    I have been brainstorming ways to use queries/filters/etc, but have not been
    able to get this to work properly. Any suggestions? If so, it would be
    extremely helpful to explicitly let me know the 'terminology' of what's
    needed, as that has been my main problem thus far.

    Thanks!
     
  2. Loading...


  3. OP
    Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    This is really, really kludgy, but here's how I accomplished that.
    You have to make sure the cursor is in the right cell, and then
    you issue the Shift + DOWN command using SendKeys.

    Me.WorkProgramID.SetFocus
    SendKeys "^+{DOWN}"

    Where you put this code will depend on what you're doing. I have
    it in the AfterInsert() of the record for the same reason you gave,
    because I want it as a reminder that there are sub records to enter.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "aheath15" <aheath15@discussions.microsoft.com> wrote in message
    news:8B48BBFC-E26F-4B9A-A198-395CA15FD6B4@microsoft.com...
    > My Situation:
    >
    > I have a list of products, some of which contain sub-assemblies, which are
    > then listed in sub-data sheets. For ordering purporses, a user can go down
    > the table and select which products are needed (using a boolean field).
    > Since some products contain sub-assemblies, I am trying to figure out the
    > best way to have these sub-assembly components automatically selected to
    > prevent the user from forgetting to order necessary products.
    >
    > I have been brainstorming ways to use queries/filters/etc, but have not been
    > able to get this to work properly. Any suggestions? If so, it would be
    > extremely helpful to explicitly let me know the 'terminology' of what's
    > needed, as that has been my main problem thus far.
    >
    > Thanks!
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page