sort list box

[HansBades]

I have a list box on a form with values. The user can add another value to the listbox through the form using a text box. It adds the new value but it adds it at the bottom of the list. I want it to sort alphabetically after it adds the new value. What is the best way to do that? Thank you!

[alansidman]

are the underlying values in the list box in a table? If so, you can sort the values in the table.

[ssanfu]

In my combo boxes and list boxes I use a query. Using a query for the Row Source allows you to select which field to sort by and the sort direction - Asc or Desc.
I never use a table as the Row Source; always a query.

[HansBades]

How do I sort the table using code? thanks

[HansBades]

I changed it to a query and sorted it that way. Much easier. Thank you both!