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.