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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box populate text boxes 6
Combo Box Look UP 3
Form won't remember last value 7
Creating a filter using VBA 5
OrderBy & Null Field Values 5
Type Mismatch Error Locks Database 2
Multi Select List Results 3
Sort data in combo box - unbounded 5

Back
Top