>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.
>
>If the RowSourceType of your dependent combos is 3-SQL Statement, all you need to do is put code like this into the Valid method of the "Master" combo box:
>
>

>WITH Thisform
>  .DependentCombo2.Requery()
>  .DependentCombo2.ListIndex = 1
>  .DependentCombo3.Requery()
>  .DependentCombo3.ListIndex = 1
>ENDWITH
>

>
>And in the Valid method of the second combo box, you would use this:
>
>

>WITH Thisform
>  .DependentCombo3.Requery()
>  .DependentCombo3.ListIndex = 1
>ENDWITH
>

Just wondering, will it be better to use interactive change event?
Luis Navas