Access97 Switchboard Manager

How can I change the text of the label depending on what switchboard I go to?

Ex.  I have a "Main Switchboard" that has a label that says "Main Switchboard".  On the Main Switchboard is a button that says "View Reports".  

When I click on this button it changes the buttons to all report options.  I want to now change the label to "Reports Switchboard"

How can I do this in code?  The switchboard manager will allow me to change the title of the Switchboard form, but I would also like to change the label.

Thanks,

Kev
kpettiAsked:
Who is Participating?
 
steve06Connect With a Mentor Commented:
Kev,

Here is a way.

Open your switchboard form in design mode. Right-click the button you have to press to display all the reports, then select properties, then the tab event. On the line "on click", you should read something like "HandleButtonClick (1)".

Replace this option by selecting from the combobox the "event procedure". Left-click on the  "..." on the right of the line, so a procedure code opens, with a new sub for the event you have just created. Add the two middle line to get:

Private Sub Option1_Click()

    Me.Caption = "This is my new title!!!"
    HandleButtonClick (1)
   
End Sub

As you should notice, if your button was called 6, replace the "1" in the sub and handlebuttonclick line by a "6".

Hope this answer your question.

Steve.
0
 
kpettiAuthor Commented:
steve06,

It worked really well!!!  Thanks for the help.

:)

Kev
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.