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
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
I don't understand the question. What is an "auto tab"? By update, you mean when a displayed value has been edited?How do I create an auto tab
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
As soon as the numeric combo box is updated, I would like access to tab to the next tab stop
When I display a numeric value in a combo box, I would like access to automatically tab to the next field
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.