Tab Order

[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

 

[Allen Browne]

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.

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

 

[Newbie]

Thanks for that -
Al

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

 

[Ed Robichaud]

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