If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drilling Down
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? |
#2
|
|||
|
|||
Drilling Down
Sorry...but I need to have the criteria both the selected service type and
the manager name. "Ray S." wrote: 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? |
#3
|
|||
|
|||
Drilling Down
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. "Ray S." wrote: 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? |
#4
|
|||
|
|||
Drilling Down
The concept you're talking about is called "Cascading comboboxes."
Here's the link for a tutorial on them at bytes.com: http://bytes.com/forum/thread605958.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
#5
|
|||
|
|||
Drilling Down
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." wrote in message ... 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? |
#6
|
|||
|
|||
Drilling Down
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. "Jeff Boyce" wrote: 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." wrote in message ... 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? |
#7
|
|||
|
|||
Drilling Down
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. "Linq Adams via AccessMonster.com" wrote: The concept you're talking about is called "Cascading comboboxes." Here's the link for a tutorial on them at bytes.com: http://bytes.com/forum/thread605958.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1 |
Thread Tools | |
Display Modes | |
|
|