Programming 3 Dependent Combo Boxes

[gyli84]

Does anyone know how to program 3 dependent combo boxes (where the values in the previous combo box limit the values in the next). I have tried a method you can use for 2 using queries as the rowsource but in trying it for 3 when I display them as part of records on a form the last comob box value always disappears whenever I switch to another record.

 

[chrismcbride]

Try this -
In the FormCurrent event refresh both the dependant combo boxes in order

ie.

cboComboBox2.Requery
cboComboBox3.Requery

HTH
Chris

 

[disgruntled]

asked the same question a month or so ago....I was referred to this page:
http://www.candace-tripp.com/_pages/HTML/default_HTML.asp

go to the cascading combo box example. Works like a charm!!!!!

 

[gyli84]

Is the cascading combo box example in the Downloads section? If it is I can't access it as there is a server error. Can someone send me the file? garyli@weconnor.com

Thanks.

P.S How did you solve your problem disgruntled? Did you have a problem getting the value in the 3rd combo to display as you flicked through records on the form even though the value was stored in the corresponding table?

 

[gyli84]

THANK YOU CHRIS!!! THE REQUERY ON FORM CURRRENT GOT THE LAST COMBO SHOWING AGAIN, YOU ARE THE BEST!