How to Sort a List Box?

[number2]

I need to sort alphebetically a list box which is used to select patient records. The box displays the last name. When clicked the record opens. The problem is I need to order the list alphebetically. Any ideas?

 

[jebry]

Hi!

Use the following as the Row Source:

Select LastName, (any other field here) From YourTable Order By LastName

hth
Jeff Bridgham
bridgham@purdue.edu