Hello all

I have a Combo box recordsource = array. say it has value like

Nancy,Crow
Mike,Smith1
Mike,Smith2
Oops,Brook

I should be able to type in the combobox say Mike and if i click the dropdown icon the record should point to first found Mike and should get incremented according to search.

Hope i made my problem clear.

Thanks for any input.