Hi Andrews,

I have something very similar. What I have done is in the GOTFOCUS of the 2nd combo I select the records that correspond to the selection from the 1st combo. I store them into the array that is bound to the control. I repeat the procedure for the 3rd based on the selections from the 1st 2 combos. I found that by putting them in the GOTFOCUS if the user wants to change one of their values, they don’t need to use the combo before.

If these combos are in a grid. Each record in the grid might have different data in the fields. Thus the bound array might not have the correct info for some of the records. You will then see blanks in the grid. Even though you have data.

To avoid this, I used a floating container over the grid. This is where I had the combos. All selecting was done there. This way the grid would always have the correct data in the different records. Vlad G. helped me a bit on the controlling of the container placement.

HTH
Mike