How to set a button to guide within a form?

[Guest]

Hello, Sirs.
I have a quite big form. There are many subforms in it. I want to add
buttons to the form and when I push one button, the subform I need will show
in the center of the window.

How can I do it?
Thanks!
Any advice is highly appreciated!

 

[Jeff Boyce]

One approach would be to use a tab control and place a sub-form on each tab.
That way, instead of needing to click a button, the user could click the
corresponding tab.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thank you for your reply. Actually. there is a tab control there. For there
are so many tabs, users have to use the arrows to explor all the subforms.
That's why I want to add some buttons to locate the tab needed.

And what should I do?

Thank you very much!

 

[Jeff Boyce]

If you add a command button to a subform, you'll need to refer to the
"Parent" form's tab control's "page" property to point to a different tab.
Check Access HELP with these keywords.

Regards

Jeff Boyce
Microsoft Office/Access MVP