Results 1 to 5 of 5
  1. #1
    Rigup is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    3

    Question Auto tab in a numeric combo box

    How do I create an auto tab after I update a numeric number in a combo box? I am new to Access and looking for help. Thanks

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    How do I create an auto tab
    I don't understand the question. What is an "auto tab"? By update, you mean when a displayed value has been edited?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Rigup is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    3
    As soon as the numeric combo box is updated, I would like access to tab to the next tab stop

  4. #4
    Rigup is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2017
    Posts
    3
    When I display a numeric value in a combo box, I would like access to automatically tab to the next field

  5. #5
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    In the control's AfterUpdate event, you can simply specify the control (by name) that Access should move to as in Me.MyControlName.SetFocus
    Or you can use code that makes use of SendKeys (a lot of people find this unreliable) or an API call to effect the pressing of the Tab or Enter key.
    Or you can use complex code that attempts to add one to the active control's tab index property and go to the next one.

    Or you can do the most simple thing of all - press the tab key and the focus will shift to the next in the tab order. If you don't like the order, change it.
    Voila! You have the same action for every control rather than placing event code in every control.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combo box: Non-Numeric values from another table
    By justin.cherveny in forum Database Design
    Replies: 9
    Last Post: 10-05-2016, 03:35 PM
  2. Auto Add new Value through a combo-box
    By raffi in forum Forms
    Replies: 5
    Last Post: 10-21-2014, 03:29 PM
  3. Replies: 3
    Last Post: 06-09-2013, 05:35 PM
  4. Alpha Numeric auto id?
    By arshadmgic in forum Forms
    Replies: 7
    Last Post: 09-02-2012, 03:00 AM
  5. Replies: 3
    Last Post: 11-04-2011, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums