Hi and thanks in advance,
I have an Access 2003 db with a form that has a Tab control and some unbound textboxes on each tab.
When the user presses the Tab or Arrow keys I want to set the tab order of all the unbound textboxes on a tab so that the user can navigate the form horizontally or vertically like a spreadsheet.
I inititally thought to capture the key pressed and simply set focus to the appropriate textbox but that caused the controls on the tab to flicker. I posted a thread on this but got no response.
The problem with resetting the tab order via VBA is that once four or five textboxes are set, they then start to renumber randomly and do not keep the tab order I set.
I tried ordering the tab index of each textbox from zero upwards and also from the max index downwards but I end up with the same problem.
Thanks
Deutz