list box

[skate]

I've got a list box displaying all my files and a textbox that I use to enter a name/location etc. to search for in the box. So basically it filters according to my entry. How do I sort in a list box? Say I enter a search for Ontario and my list filters for Ontario, but I want to sort these items by city?

 

[jimbrooking]

Is the rowsource for the listbox a query (SQL)? If so just add to the end of the query

ORDER BY CityName

so the query will look something like

SELECT fields FROM table WHERE Province="Ontario" ORDER BY CityName;