Form - Sort Dropdown by Name

[jmadero]

Hi All,

Trying to get dropdowns in a form to sort by name instead of by the ID which the corresponding table is sorted by.

DB: https://drive.google.com/file/d/1kCiKTw ... sp=sharing
Form: MyLibrary

Dropdown: Title

Help appreciated.

[Villeroy]

Data properties of a listbox, applies to 99% of all listboxes:
Linked field: the field where the listbox value is written to
Source type: SQL or Query (Query if you don't want to compose the same SQL for many equal listboxes)
Source: Either SELECT "Visible Text", "Primary Key" FROM "Somewhere" ORDER BY "Visible Text" or the name of the query having this statement.
Bound field: 1 which is the second field, the primary key of somewhere. 0 is the visible field.

[UnklDonald418]

On the MyLibrary form document the control labled Title is actually a TextBox. On the Data tab of the Form Properties dialog is a Sort option.
For your Author ListBox, on the Data tab of the Properties: List Box dialog add

Code: Select all

ORDER BY  "AuthorName"

to the List content query.
Since the AuthorName field isn't split into First and Last names the results will be sorted by first names and then last names.
Similarly, you can add ORDERY BY clauses to the Series and Genre list boxes.

[jmadero]

Happy to mark this as solved and open a new related question but just in case it seems appropriate and related so here it goes:

DB: https://drive.google.com/file/d/1kCiKTw ... sp=sharing
Table: MyLibrary
Record #: 8
Title: The Riddle

Observed:
"Books in Series" are not in order based on # in Series, instead they appear to be in order by BookID

Question:
Anyway to make this subform organized by # In Series?

You two have both been amazing and I appreciate all the help.

[UnklDonald418]

The Data tab of every Form Properties dialog has a Sort option. As long as the field you need is on the list, that should do it.
The other option would be to create a new query for that SubForm.