• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

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
0
kpetti
Asked:
kpetti
1 Solution
 
steve06Commented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now