Returning to the correct Tab (page)

[Tony]

Help!
I have successfully created a main menu using the multi-
tab format and my users love it!

However, on some of the tabs, there are buttons to call
data entry screens. When they return to the main menu, it
defualts to the first tab (page).

I do not see any documentation for a way to get the Access
2000 to return to tab 3 (for example) using
the "DoCmd.OpenForm" command.

Any Ideas?? or Work-Arounds??

Thanks!!

 

[Greg Kraushaar]

When you close the form, save the TabControl.Value (OnClose Event)
then when you open it again,
set it from your saved Page Number (OnOpen Event)

The Registry is a good place for this Stuff
Look up GetSetting in Help

Regards Greg Kraushaar
Wentworth Falls Australia
(Do not email - the reply address is a Spam spoofer)
(If you really must, remove all UCase and numbers)

 

[Rick Brandt]

Help!
I have successfully created a main menu using the multi-
tab format and my users love it!

However, on some of the tabs, there are buttons to call
data entry screens. When they return to the main menu, it
defualts to the first tab (page).

I do not see any documentation for a way to get the Access
2000 to return to tab 3 (for example) using
the "DoCmd.OpenForm" command.

Any Ideas?? or Work-Arounds??

The easiest would be to simply hide the menu form instead of closing it.
Then when you make it visible again it will be in the same state as before.
\