I have a table named Contacts with a First and last Name field and then a combo box on a form named issues that uses a drop down to select one of these contacts. I also have an Add button next that pulls up the Contacts form and allows for someone to add a new contact name to the table and thus adding it to the drop down for next time. I am trying to get that to sort by Last Name then First name and I am not having much luck. Any help would be appreciated.

Thanks

Personally I prefer to base the Combo Box on a Query and do the sorting in the Query.

Set the Oder By property for the dropdown to Last name, first name

And where do i find that order by property for the drop down? I looked the property list and didn't see it or am i looking in the wrong spot?

Thanks