unbound list box sort

[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

 

[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.

 

[PC Datasheet]

Change the rowsource to a query and sort on LName.

 

[John]

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.