Run a SQL SELECT that loads the second and third combos dynamically based on the values in the earlier combos. You can place the code in the refresh of the other combos.
>I have 3 combo boxes and 1 grid. I want to be able to use the first combobox which will filter what is shown in the 2nd combo box, and the 3rd combobox is based on the first 2 combo boxes.
> Currently in the combo init I use a SQL to additems, and default combobox to "ALL Records". Once the combo boxes are initiated, the information is pretty much locked in there.
> Where do I put the code so the combo boxes gets filtered based on pervious choices? What is the best way to do it?
>
>TIA,
>
>Jim
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer