>there is a special requirement in the order of the list showing in the combo box.
>3 of the names should always be shown on the top of the list while the others
>should be shown according to the alphabetical order.

You can put code in the combo's Requery() event so that you .AddItem the top three
followed by the rest of the table, sorted. You may also need to do this at .Init()
time as well. Do you need code, or is this enough of a nudge?