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
Code:
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.[Color Red]Name of new Control[Color Black] = 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![Bigcheeks]
