Visible Buttons

[lambej12]

I have a 12 tab Access form. There are sub forms built into one main
form with the tabs, but they are all constructed differently in size.
I would like to stack about 8 buttons on the main form and make the
buttons visible as the tabs are worked through. The buttons are going
to be linked to a Word document that will have help instructions for
that particular tab. Can someone help me with the code to make the
buttons visible based on the user clicking on the tab name. Thank you.

[MGFoster]

la******@nationwide.com wrote:

I have a 12 tab Access form. There are sub forms built into one main
form with the tabs, but they are all constructed differently in size.
I would like to stack about 8 buttons on the main form and make the
buttons visible as the tabs are worked through. The buttons are going
to be linked to a Word document that will have help instructions for
that particular tab. Can someone help me with the code to make the
buttons visible based on the user clicking on the tab name. Thank you.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You use the .Value property of the Tab control. It indicates the pages,
starting from zero, that were just clicked.

Private Sub TabCtl0_Change()
MsgBox "Page: " & TabCtl0.value
End Sub

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRFJTMYechKqOuFEgEQKFXACggvfRPcVIm9eK5J+UaWwLsn l5LoQAn3er
nkGbyKOka4syLxqDCz0xNF6+
=+hSr
-----END PGP SIGNATURE-----

[Jana]

IMHO, You may be better off with one button, whose function is
determined by the page they are on, rather than stacking 8 buttons and
dealing with hiding/showing the applicable button.

HTH,
Jana

[Ron2005]

less code that way because you would have to set 7 off and 1 on for
each condition.
instead use

select case in the onclick event of the button to determine which one
to call. If you want a button for help for the Main form that will have
to be a different one, because the tab number will be set to the last
one used and not changed when you return to the main form (besides you
are in a sense changing to the main form when you press the help
button.

You could also place a button on each of the tabs but in the same place
that would get the help for that particular tab.