I feel like I'm doing something very stupid. I'm using access 2007.
I've got a combobox, and I want the newest items (sortable by ProjectID or R_number - it doesn't matter) at the top.
The row source is
SELECT DISTINCTROW Projects.ProjectID, Projects.R_number, Projects.recv_date...