Contact US

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.

Students Click Here

Microsoft: Access Other topics FAQ

Choosing the Correct Forum

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


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], "")
End Sub

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

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

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

I hope this help some of you

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

My Archive

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