Combo Box Order

[fatbloater]

I have a combo box that is generated by a query. The query looks at a table that contains date and time values, the problem i am having is with the order that combo box displays this query. i have gone into the row source and told the query to display most recent date first and this works, but when you use the combo box on the form it does not, it displays the oldest first - weird!

Can anybody help?

 

[quest4]

In the query, in the date column is sort set to decending? Why are you using a query for a combobox? Is there a calculation going on? If not set the Row Source to the table and you sort in the Before UpDate. hth.

 

[Rusty]

Hey fatbloater,

I've come up against this problem in the past. The best way I found to get around it is to use the builder for the Row Source property of the combobox.

A detailed tutorial on this can be found at:
http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials/combo.pdf

Pages 16 to 19 are the ones you want. This will enable you to customise the order your comboboxes display the dropdown lists, even if the query/table they are based on has a specified order, and even if more than 1 combobox on the same form is pointing to the same source.

Hope this helps,

Rusty

 

[fatbloater]

Sort in the before update?
I will have alook at the PDF file - cheers.