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
|
|||
|
|||
synchronize more than two combo boxes on a form in Access
Using Microsofts Database sample forms - specifically using multi combo boxes
(see link below) I amnaged to learn alot about what I wanted to do. Typically I want to do more! I am a bit of a newbie, so please excuse my lack of terms. Basically using the form I mentioned it allows you to select data from one combo box, and that data is filtered into the next one (dependant on what you select in the first) what I want to do is have 4 combi box's with a 5th text box resulting in a yes / no. Does anyone know if this is possible? Any pointers in the right direction would be appreciated. I do want to say, from what I have seen upto now, you guys do a great job on this!! Thanks How to Synchronize two combo boxes on a form: Link : http://www.microsoft.com/downloads/d...8-78E549ECD14C |
#2
|
|||
|
|||
synchronize more than two combo boxes on a form in Access
Just do it again 4 more times
The term applied to filtering one combo on another is often Cascading Combos. If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4 simple as that. -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Using Microsofts Database sample forms - specifically using multi combo boxes (see link below) I amnaged to learn alot about what I wanted to do. Typically I want to do more! I am a bit of a newbie, so please excuse my lack of terms. Basically using the form I mentioned it allows you to select data from one combo box, and that data is filtered into the next one (dependant on what you select in the first) what I want to do is have 4 combi box's with a 5th text box resulting in a yes / no. Does anyone know if this is possible? Any pointers in the right direction would be appreciated. I do want to say, from what I have seen upto now, you guys do a great job on this!! Thanks How to Synchronize two combo boxes on a form: Link : http://www.microsoft.com/downloads/d...8-78E549ECD14C |
#3
|
|||
|
|||
synchronize more than two combo boxes on a form in Access
Hi,
Thanks for the quick response, but I am new to this, and only managed to do waht I did having it layed out by the template. As I do not understand all the ins and outs I still do not have much of a clue how to modify it, ie the sql, does it need changing, do I need to modify the quirie? As like the template used it uses 'lookup' into another table for each combobox. Appologies for been a bit thick, and maybe Im trying to run before I can walk, but I aint gor much choice, as my boss is expecting me to do this! All help is very much appreciated. Regards Mark "Klatuu" wrote: Just do it again 4 more times The term applied to filtering one combo on another is often Cascading Combos. If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4 simple as that. -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Using Microsofts Database sample forms - specifically using multi combo boxes (see link below) I amnaged to learn alot about what I wanted to do. Typically I want to do more! I am a bit of a newbie, so please excuse my lack of terms. Basically using the form I mentioned it allows you to select data from one combo box, and that data is filtered into the next one (dependant on what you select in the first) what I want to do is have 4 combi box's with a 5th text box resulting in a yes / no. Does anyone know if this is possible? Any pointers in the right direction would be appreciated. I do want to say, from what I have seen upto now, you guys do a great job on this!! Thanks How to Synchronize two combo boxes on a form: Link : http://www.microsoft.com/downloads/d...8-78E549ECD14C |
#4
|
|||
|
|||
synchronize more than two combo boxes on a form in Access
There are two basics.
Comb2 has to filter on the contents of Combo1. It can be one or more columns in Combo1, but le'ts take baby steps. So Combo2 has to have Combo1 in the Row Source query's WHERE Clause: SELECT Froz, Whippie FROM tblDogle WHERE Whippie = Forms!FormName!Combo1; (over simplified and absurd, but the basic idea.) Now when you change the selection in Combo1, you need to Requery Combo2, so you use the After Update event of Comb1: Me.Combo2.Requery Now, to build Comb3 so it depends on Combo2, pretend Combo1 doesn't even exist. That will keep you from getting confused about whether you need to consder it. That is the whole concept in a nutshell. By next week, you will be running track -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Hi, Thanks for the quick response, but I am new to this, and only managed to do waht I did having it layed out by the template. As I do not understand all the ins and outs I still do not have much of a clue how to modify it, ie the sql, does it need changing, do I need to modify the quirie? As like the template used it uses 'lookup' into another table for each combobox. Appologies for been a bit thick, and maybe Im trying to run before I can walk, but I aint gor much choice, as my boss is expecting me to do this! All help is very much appreciated. Regards Mark "Klatuu" wrote: Just do it again 4 more times The term applied to filtering one combo on another is often Cascading Combos. If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4 simple as that. -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Using Microsofts Database sample forms - specifically using multi combo boxes (see link below) I amnaged to learn alot about what I wanted to do. Typically I want to do more! I am a bit of a newbie, so please excuse my lack of terms. Basically using the form I mentioned it allows you to select data from one combo box, and that data is filtered into the next one (dependant on what you select in the first) what I want to do is have 4 combi box's with a 5th text box resulting in a yes / no. Does anyone know if this is possible? Any pointers in the right direction would be appreciated. I do want to say, from what I have seen upto now, you guys do a great job on this!! Thanks How to Synchronize two combo boxes on a form: Link : http://www.microsoft.com/downloads/d...8-78E549ECD14C |
#5
|
|||
|
|||
synchronize more than two combo boxes on a form in Access
Thanks for laying out simple. Will give it a try at work tom. Thanks again!!!!
Mark "Klatuu" wrote: There are two basics. Comb2 has to filter on the contents of Combo1. It can be one or more columns in Combo1, but le'ts take baby steps. So Combo2 has to have Combo1 in the Row Source query's WHERE Clause: SELECT Froz, Whippie FROM tblDogle WHERE Whippie = Forms!FormName!Combo1; (over simplified and absurd, but the basic idea.) Now when you change the selection in Combo1, you need to Requery Combo2, so you use the After Update event of Comb1: Me.Combo2.Requery Now, to build Comb3 so it depends on Combo2, pretend Combo1 doesn't even exist. That will keep you from getting confused about whether you need to consder it. That is the whole concept in a nutshell. By next week, you will be running track -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Hi, Thanks for the quick response, but I am new to this, and only managed to do waht I did having it layed out by the template. As I do not understand all the ins and outs I still do not have much of a clue how to modify it, ie the sql, does it need changing, do I need to modify the quirie? As like the template used it uses 'lookup' into another table for each combobox. Appologies for been a bit thick, and maybe Im trying to run before I can walk, but I aint gor much choice, as my boss is expecting me to do this! All help is very much appreciated. Regards Mark "Klatuu" wrote: Just do it again 4 more times The term applied to filtering one combo on another is often Cascading Combos. If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4 simple as that. -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Using Microsofts Database sample forms - specifically using multi combo boxes (see link below) I amnaged to learn alot about what I wanted to do. Typically I want to do more! I am a bit of a newbie, so please excuse my lack of terms. Basically using the form I mentioned it allows you to select data from one combo box, and that data is filtered into the next one (dependant on what you select in the first) what I want to do is have 4 combi box's with a 5th text box resulting in a yes / no. Does anyone know if this is possible? Any pointers in the right direction would be appreciated. I do want to say, from what I have seen upto now, you guys do a great job on this!! Thanks How to Synchronize two combo boxes on a form: Link : http://www.microsoft.com/downloads/d...8-78E549ECD14C |
#6
|
|||
|
|||
synchronize more than two combo boxes on a form in Access
Hi Klatuu,
Your going to think Im completely useless, but I cant get it to work. Basically I do not know what exactly to change / add from the template from microsoft. I think I am doing some of it right, but just need to know the exact changes. This is alot to ask, and would understand if you cannot give me the time, as Im sure you have better things to do, and will just have to keep trying. Let me know if you can help further. Regards Abbsy3 "Klatuu" wrote: There are two basics. Comb2 has to filter on the contents of Combo1. It can be one or more columns in Combo1, but le'ts take baby steps. So Combo2 has to have Combo1 in the Row Source query's WHERE Clause: SELECT Froz, Whippie FROM tblDogle WHERE Whippie = Forms!FormName!Combo1; (over simplified and absurd, but the basic idea.) Now when you change the selection in Combo1, you need to Requery Combo2, so you use the After Update event of Comb1: Me.Combo2.Requery Now, to build Comb3 so it depends on Combo2, pretend Combo1 doesn't even exist. That will keep you from getting confused about whether you need to consder it. That is the whole concept in a nutshell. By next week, you will be running track -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Hi, Thanks for the quick response, but I am new to this, and only managed to do waht I did having it layed out by the template. As I do not understand all the ins and outs I still do not have much of a clue how to modify it, ie the sql, does it need changing, do I need to modify the quirie? As like the template used it uses 'lookup' into another table for each combobox. Appologies for been a bit thick, and maybe Im trying to run before I can walk, but I aint gor much choice, as my boss is expecting me to do this! All help is very much appreciated. Regards Mark "Klatuu" wrote: Just do it again 4 more times The term applied to filtering one combo on another is often Cascading Combos. If 2 is filtered by 1, the filter 3 by 2, 4 by 3, and 5 by 4 simple as that. -- Dave Hargis, Microsoft Access MVP "Abbsy3" wrote: Using Microsofts Database sample forms - specifically using multi combo boxes (see link below) I amnaged to learn alot about what I wanted to do. Typically I want to do more! I am a bit of a newbie, so please excuse my lack of terms. Basically using the form I mentioned it allows you to select data from one combo box, and that data is filtered into the next one (dependant on what you select in the first) what I want to do is have 4 combi box's with a 5th text box resulting in a yes / no. Does anyone know if this is possible? Any pointers in the right direction would be appreciated. I do want to say, from what I have seen upto now, you guys do a great job on this!! Thanks How to Synchronize two combo boxes on a form: Link : http://www.microsoft.com/downloads/d...8-78E549ECD14C |
Thread Tools | |
Display Modes | |
|
|