Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Label Caption between Two Switchboards (03)

    I have a label on SB_01 whose caption is "Forms". When I call SB_02 the label's caption remains the same ie "Forms". I would like to change it to "Reports" and revert back to "Forms" once I return to SB_01.

    Also is it possible to have the SB immediately open upon access the DB?

    Thanks,
    John

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing Label Caption between Two Switchboards (03)

    Without knowing exactly which label you're talking about, it's hard to give advice.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing Label Caption between Two Switchboards (03)

    To open the switchboard when the database is opened:
    - Select Tools | Startup.
    - Set the Switchboard form as startup form in the Display Form/Page dropdown.
    - Set other strtup options if desired.
    - Click OK.

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Label Caption between Two Switchboards (03)

    Hans,

    On SB_01 if I highlight the label (it is a label) it is described as Label: Label22 with a caption of "Forms". The caption does not change when I go to SB_02.

    Hope this helps.
    John

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Changing Label Caption between Two Switchboards (03)

    There is an On Current event procedure for the switchboard form:
    <code>
    Private Sub Form_Current()
    ' Update the caption and fill in the list of options.
    Me.Caption = Nz(Me![ItemText], "")
    FillOptions
    End Sub
    </code>
    Change it to
    <code>
    Private Sub Form_Current()
    ' Update the caption and fill in the list of options.
    Me.Label22.Caption = Nz(Me![ItemText], "")
    FillOptions
    End Sub
    </code>
    Modify the names of the label if necessary. Does that do it? If not, please attach a stripped down and zipped copy of the database with just the switchboard.

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Changing Label Caption between Two Switchboards (03)

    One thing to note that upon initally setting up the switchboard, the switchboard items table contains "item text' for SB_01 defaulting to "main switchboard". One needs to change this as well.

    Regards,
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •