Results 1 to 3 of 3

Thread: Listbox order?

  1. #1
    Join Date
    Aug 2004
    Posts
    364

    Unanswered: Listbox order?

    I have a listbox on a form which shows the Id's and names for people in another form (and table) in my database. I can select a row in the listbox and double click to open the form to display the full contents of the record.

    The listbox's order of the Id's and names which relate to the records don't appear to be in any sort of order however... How can I get the listbox to display the records in order of when they were entered? eg descending order? Just so it is easier to see when which are the newest entries.

  2. #2
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    You can base the list box on a query with the sort order you prefer.
    Darasen

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    yourListBox.RowSource="SELECT Field1, Field2 FROM yourTable ORDER BY Field3"
    yourListBox.Requery

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •