Sort drop down list

[LKalka]

I have a table in which one column is a drop down list that gets its info from another table called Customers. The problem is that the list of customers doesn't sort when you add new ones. So you have to look through the entire list to find the customer you want to use. The users then sometimes end up creating a new, duplicate customer by entering a name that is only slightly different from the existing entry i.e. use Ltd. on one and not on the other.

Is there a way to have this list sort automatically when new customers are added??

 

[jdegeorge]

On your form, in the AFTER UPDATE propery of the dropdown box, create an event and add

Me.Refresh

as the code.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."

 

[mikey69]

The standard way around this problem is to use a query as the data source for the combo box and put the appropriate sort in the query grid.