How do I cascade combo box

[huichun]

I have 3 combo box on my form and would like to see box3's data based on box2's selection and box2's data based on box1's selection.
Anyone there can help?

Thank you!!

 

[CCLINT]

On the click event of a combo box, get the current item value and use that as criteria when executing/requerying the underlying recordset for the next level combo box, or, use it with the ADO Filter method for that recordset. [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!