Synchronising multiple combo boxes

[j w]

Hello there,

I've been using the Microsoft guide to synchronise two combo boxes
that the second combo box is dependent on the first combo box's
selection as described here: http://support.microsoft.com/kb/289670

I'd like to link a third combo box but can't find any step by step
instructions on how to do this.

Many thanks in advance.

 

[ManningFan]

Do the same thing you did for the second. Essentially, on the
AfterUpdate you are going to requery the 3rd box (or update its
recordsource, whichever you're doing). The recordsource may need to
look at the values of both the first and second combo, so make sure
you include both of them in your "WHERE" clause.

 

[David W. Fenton]

m:

I've been using the Microsoft guide to synchronise two combo boxes
that the second combo box is dependent on the first combo box's
selection as described here:
http://support.microsoft.com/kb/289670

I'd like to link a third combo box but can't find any step by step
instructions on how to do this.

Surely making combo box 3 dependent on combo box 2 would be a
process no different from making combo box 2 dependent on combo box
1 -- all you'd do would be to change the names of the combo boxes
involved.

What have you tried?

 

[ManningFan]

Surely making combo box 3 dependent on combo box 2 would be a
process no different from making combo box 2 dependent on combo box
1 -- all you'd do would be to change the names of the combo boxes
involved.

Actually, it could. Combo 3 could be reliant on the content of both
Combo 2 and Combo 1 as I stated above.