This works for me:Private Sub cboPlant_Change()cboUnit.ListIndex = -1Select Case cboPlant.ValueCase "Clark"cboUnit.RowSource = "Clark"Case "Lenzie"cboUnit.RowSource = "Lenzie"End SelectEnd Sub