Customize switchboards to make each unique to the user?

G

Guest

Access 2003, need to customize switchboard and sub-switchboards to make more
efficient. Need to title each switchboard with title other than the name of
the Database.
 
J

Jeff Conrad

Access 2003, need to customize switchboard and sub-switchboards to make more
efficient. Need to title each switchboard with title other than the name of
the Database.

Through code in like the form's Current event just change the caption
that is on the top of the form. I only have Access 97 in front of me at
the moment so I know this will be different than Access 2003, but
something like so:

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

Me.Caption = Nz(Me![ItemText], "")
FillOptions
Me.Label1.Caption = "Some Other Text Here"

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top