Drilling Down

[Ray S.]

I want to have a form where I can select from a combo box among "Service
Types" (there are three of these). Then, based on the selected type, I want
another combo box to display a list of the "managers" within each service
type. (there are sixty managers in each service type). I want further to be
able to double-click on the name of a manager and display the results of a
query having the selected manager as its criteria. Now, I can easily enough
do the first step using a combo box, but I am having difficulty making the
second combo box on my form work. I figure that once I can get that part to
work, then I can set up a double-click event procedure that will run my query
(if I can figure how to make the item clicked on be the criteria for the
manager name). Can I get some guidance on this?

 

[Ray S.]

Sorry...but I need to have the criteria both the selected service type and
the manager name.

 

[Golfinray]

Start with Allen Brownes method at www.allenbrowne.com or check Martin Green
at www.fontstuff and then come back. That ought to get you started so you can
come back and ask some specifics.

 

[Jeff Boyce]

Ray

Not sure what "the results of a query with the selected manager" will be.
Is this likely to be a single field or dozens? Is this likely to be a
single row, or dozens?

One approach I've used to do something similar is to build the first
combobox to list all XXXXs. A second combobox is refreshed when the choice
is made in cboONE and shows only YYYYs that belong to the choice of XXXX.

Then I use a listbox to display all the ZZZZs that belong to the YYYY I
selected (that belongs to the previously-selected XXXX).

Does that approximate what you're trying to do? If so, that query you
mentioned would be the source of the listbox I mentioned.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Ray S.]

Thanks Jeff,

I'm checking the other response suggestions, too; but to answer your
questions, the queries will have dozens of fields - actually, I plan on
producing formatted reports instead of just providing the results in
datasheet form.

 

[Ray S.]

Thanks Ling,

Yes, the tutorial is helpful if basic. I think that is what I'm doing on my
form to be able to select one of the referred to three service types in my
first combo box. Then, upon that selection, the second combo box is populated
with the list of managers for each type. It's a good start.