Move From 1 Tabbed Panel to Next Automatically in Multi-Tab Form

[Guest]

I have a single form designed with 5 different tabbed panels attached to it.
They all appear to work fine in data entry/update/etc mode. My problem is I
need to find out how to make the tabbed panels flow or scroll automatically
(if it can) as the user enters data into the last field of the first panel to
scroll to the next sequentially assigned tabbed panel, and on to the last
before writing the record. Can this be done on an automatic basis, or do I
have to create a Command button to flow to the next. I want to assist the
user on an automated basis, to flow smoothly without having to move the
cursor (mouse) to the tabbed panel and click, to move smoothly as the last
data field on each panel is filled with data or auto-tabbed through to scroll
to the next tabbed panel, next tabbed field. Any suggestions. Thanks in
advance. Robert Nusz, DPS, Oklahoma

 

[John Spencer (MVP)]

One method is to add a transparent button as the LAST control in tab order on
each tabbed panel.

Then use the gotfocus event of the button control to move the focus to the first
control on the next tabbed panel. You can even add a button as the first
control on each tabbed panel and use it to move to the previous tabbed panel.

 

[Guest]

John,

Thanks for responding for the suggestions. I was able to create and execute
a macro "GoToControl" and forward the form to the next tabbed panel-first
field of entry position. This worked well by also adding a Command button as
the last control field on the screen that I was leaving and let the fields
auto-tab down to that position, thus, rotating me on into the next panel,
first field. I do appreciate your suggestion and will keep these replies and
consider them as well for future projects.

Thanks again,
Robert Nusz - DPS, State of Oklahoma

 

[Guest]

One other thing you might find helpful . .

If you hit Ctrl-Tab, it will automatically cycle to the next tab in the tab
control.

John,

Thanks for responding for the suggestions. I was able to create and execute
a macro "GoToControl" and forward the form to the next tabbed panel-first
field of entry position. This worked well by also adding a Command button as
the last control field on the screen that I was leaving and let the fields
auto-tab down to that position, thus, rotating me on into the next panel,
first field. I do appreciate your suggestion and will keep these replies and
consider them as well for future projects.

Thanks again,
Robert Nusz - DPS, State of Oklahoma

 

[Guest]

Stacey, I will make note of this information in my user guide for the people
that will be using this application.

Thanks for responding. It's been a great help.

Robert @ DPS