unbound list box sort

J

John

I have an unbound list box, that displays 3 columns of data MR,FName,LName.
Is there a way to have the data in the list box sorted according to LName
(lastname). Right now they appear to be showing in order that the records
were entered.

Thanks
 
S

Steve Schapel

John,

Set the Row Source of the listbox to a Query where you can sort by the
LName field, or to the equivalent SQL statement with an ORDER BY clause.
 
J

John

Thanks
Steve Schapel said:
John,

Set the Row Source of the listbox to a Query where you can sort by the
LName field, or to the equivalent SQL statement with an ORDER BY clause.
Click to expand...
 
Top