unbound list box sort

  • Thread starter Thread starter John
  • Start date Start date
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
 
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.
 
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...
 
Back
Top