synchronize more than two combo boxes on a form in Access

[Abbsy3]

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/details.aspx?FamilyId=7A50205E-A29B-4A43-8508-78E549ECD14C

 

[Klatuu]

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.

 

[Abbsy3]

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]

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

 

[Abbsy3]

Thanks for laying out simple. Will give it a try at work tom. Thanks again!!!!

Mark

 

[Abbsy3]

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