Automatic sorting

I have a combobox that when it finds something not in the list, it starts a form that asks for the necessary information to create a record in the database for the advertiser. Is there a way for the form when it creates the new advertiser to automatically insert the record into its alphabetical spot in the list?

Your combo box's row source should be a query that has a sort on it. If you do that then when Access adds the new item, if you are using the special Not In List form assignment that 2007 has, it should add the value to the combo box and then it will be in the correct sort order.

Tables are not stored in any particular order and setting the orderby property on a table isn't useful anywhere but in the table. You need to use a query to get exactly what you want.