Tab Order

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

Hi

How can I get the Tab to move to a command button in the footer of the form.
At the moment the Tab just goes between the 2 controls in the detail section
 
Add a small, unbound text box to the Detail section.

In it's GotFocus event procedure, SetFocus to the command button.

You may wish to check Screen.PreviousControl to see if you Shift+Tab'd
backwards into this box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


Newbie said:
How can I get the Tab to move to a command button in the footer of the form.
At the moment the Tab just goes between the 2 controls in the detail
Click to expand...
section
 
Thanks for that -
Al
Allen Browne said:
Add a small, unbound text box to the Detail section.

In it's GotFocus event procedure, SetFocus to the command button.

You may wish to check Screen.PreviousControl to see if you Shift+Tab'd
backwards into this box.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.



section
Click to expand...
 
As you discovered, the tab and form footer controls are in different parts
of your form and the tab order property wizard will not show them at the
same time. One solution is to use the "on exit" event of the tab control to
run some simple VBA code to move the focus to another part of the form.

SetFocus.Forms!frmMyForm!ctlMyControl

-Ed
 
Back
Top