Selecting Order of Options in List box with Two Fields

[GregShah]

I created a query that lists the ship date and job number for each part number in the query. I sorted my query so the parts are listed first by ship date and then by job number. This will keep the most current parts near the top of the list box and save time scrolling.



In my query, the parts sort correctly, first by delivery date and grouped by job number.

However, when I use my list box on my form, the order does not match the order in the query.

I there a way to match the list box to match the query order exactly?

Thanks,

Greg

[pbaldy]

What is the row source of the listbox? If it's the query itself, I'd expect the order to be respected.