>How can sort the data in combo box.load only requaried records in combo box
>There are records for year 2004,and 2003. sort the record for 2003.
It's simpler to use a SQL select as rowsource for the combo - and in it you can have any Where clause you want, and any Order By, so all sorts of filtering and sorting are at hand. And it takes just a simple combobox.Requery() to get a fresh set of data.