INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Choosing the Correct Forum

Make the Switchboard Title = the Swithcboard Caption by RobPotts
Posted: 7 Nov 02

Hello,

Rather thatn have loads of Forms as Menues I decided to stick with switchboards once I learn that you could use more than 8 items and customise the look of the switchboard.
see Thread700-174910

But I wanted the title of the Menu to change for each new page.  To do this I decided to link the title to the cation of the switchboard which I noted did change.  To do this:

1. Open the  switchboard in design view.

2. Add unbound controls.  Format these as you want them to apear on the form as the tile (I formated two controls the same as the 2 labels which are automatically created with the switch board)

3. Delete the original switchboard labels

4. Open the code for the form and Find the on current code, it will look like

Private Sub Form_Current()
' Update the caption and fill in the list of options.

    Me.Caption = Nz(Me![ItemText], "")
    FillOptions
       
End Sub


5. Add the following, for each control to this code

Me.Name of new Control =  Nz(Me![ItemText], "")
    FillOptions

You should now have a Switchboard Title that changes with each new Page.

I hope this help some of you
Rob!

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close