Tabbing within Form problem

I use Access 2003. I have a form that contains tabs with fields within each
tab. I also have two fields outside of the tabbed area. How do I make it
[TAB] from the last field outside of the tabs to the first field within the
tabs?

Mark wrote:
I use Access 2003. I have a form that contains tabs with fields
within each tab. I also have two fields outside of the tabbed area.
How do I make it [TAB] from the last field outside of the tabs to the
first field within the tabs?

Add another unbound TextBox on your form (not on a TabPage). It needs to
have its Visible property set to True, but you can make it zero height and
width so that the user cannot see it. Put it in the TabOrder after your
second control that is not on the TabControl.

Now, in the GotFocus event of this "dummy" control add a line of code to set
focus to the desired control on the TabControl. When the user tabs out of
the last "real" control they will automatically be taken to the desired
control on the desired TabPage.

This is also can also be used so when you tab out of the last control on the
first TabPage to automatically be taken to the first control on the next
TabPage.

The purpose of the dummy controls is so that the automatic tabbing only
occurs when they tab out of the last real control into a dummy control. If
instead you set focus with the Exit or LostFocus event of your existing
control then even if the user left that control with the mouse (to click on
whatever), the code would force the focus to a control that they did not
want to go to.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com