>Is there any other way to sort the combobox by lastname and firstname?

You can set the row source to SQL statement then create the SQL statement in rowsource with the correct ORDER BY

Rpb