Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2009
    Posts
    3

    Unanswered: Changing "tab order" w/ vba code.

    Hello all, I currently have a form where you enter the steps required to make a product. The user would select the operation from a multi-select list box then select step #1 and click the "next step" button. When you click the "next step" button, It currently increases the step # and goes to the next record which is perfect, but I'd like it to also set the tab to the operation list box, so the user can just type or select the next operation w/o having to click on that box. I know this has to be added into the "next step" on click event, but I'm not sure what I have to put. This should be easy I think, but i've never done this before. Thank you very much.
    -justin.
    Last edited by Justns11; 04-23-09 at 13:40.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Me.<Control>.TabIndex = 2

    But you have to keep track of the tab indexes of the other controls and eventually change them too because several controls cannot have the same tabindex number at the same time.

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You can use code such as Me.OperationListBoxControlName.SetFocus to move the cursor to a specific control on a form. Changing the TabIndex as Sinndho suggests is not going to do what you want.

    I think Sinndho only read the title of the topic
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    at last!! Smilies are working with normal text!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    But they are still lame. I don't see how colon and o should make a

    Vote1 more smilies!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Apr 2009
    Posts
    2

    Tab order

    erties and their set the number format for the text box

    Quote Originally Posted by StarTrekker
    But they are still lame. I don't see how colon and o should make a

    Vote1 more smilies!!

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes.... and that makes sense... on some level. What level exactly I don't know
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •