Switchboard items

[Mani]

Ok.. hopefully my question makes sense, but here it goes. I've added a new
item (Student Services) on the main switchboard and when I click on the it
gives me three items (Jane, Joe, and Bob's name). Now when I click on each
of the name, I want it to give me items (school names) for each person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to the names, then
i won't let me creat new items, so I have to give commands for each name,
which I do not want to yet. I want to execute the command after creat new
items (schools). Is there a way I can do that?? Please HELP me!! :-(

 

[Mani]

How no one is helping me out? I've been waiting for an answer for about two
weeks now.

 

[Larry Daugherty]

You're much too patient! During the week waiting a day would be
reasonable. Most posts get a response in minutes or hours. Be a
little more patient if your post is late Friday or over the week end.

As given, your question doesn't make sense to me.

For starters, what version of Access are you using?

The Switchboard Manager doesn't offer very many actions. There are
none that implicitly lead to the presentation of results from or on a
switchboard. Usually you'd open another Switchboard or a Form or
Report, etc. from a command button on a Switchboard.

Please respond with the name of the Switchboard and the name or label
of each item on it and the desired action; open another switchboard,
open a Form, open a Report, ??

If, by chance, you opened the table "SwitchboardItems" and entered
data directly into it, that's probably the source of your problem.

If you're creating your own switchboards from scratch then they have
to be addressed simply as Forms with command buttons.

HTH
--
-Larry-
--

Ok.. hopefully my question makes sense, but here it goes. I've added a new
item (Student Services) on the main switchboard and when I click on the it
gives me three items (Jane, Joe, and Bob's name). Now when I click on each
of the name, I want it to give me items (school names) for each person (Jane,
Joe, and Bob). But it's not letting me do it. once I get to the names, then
i won't let me creat new items, so I have to give commands for each name,
which I do not want to yet. I want to execute the command after creat new
items (schools). Is there a way I can do that?? Please HELP me!!

:-(

 

[Mani]

Ok. For example.. let's say I have a main switchboard with 8 items and on
one of the items (Counselor switchboard), I want the Counselor switchboard to
give me the names of the Counselors (for example Jane, Joe, Bob, and Jill).
So when I select the names I want i the school names for each counselor. so
if i were to diagram it, it would go as follows... Main Switchboard (which
has the Counselor switchboard)-------> then I click on the Counselor
switchboard-------> then I have Jane, Joe, Bob, and Jill-------> then I click

 

[Larry Daugherty]

I've been away for a while.

To achieve your desired outcome you should not be trying to use the
switchboard manager down to the lowest level. Instead, have the
command on the Main Switchboard open a Form that will allow you to
select the counselor and schools. frmCounselorSchools should allow
you to pick a counselor from either a combobox or a listbox. Using
the appropriate event for the type of control you choose, either show
the appropriate schools in a subform on frmCounselorSchools or open an
entirely different Form or Report showing just the selected counselor
and the appropriate list of schools.

There is a huge flaw in what you were trying to do. "Hard wiring"
individual names in command buttons means that you are creating an
application that will require maintenance with every change of
personnel. Using the paradigm suggested above will only require
changing the record in the table that lists the counselors.

HTH