Dates won't sort in a Form

[Frankie_The_Flyer]

I have a "Date Select" form that is linked directly to a table that only has one column in it, "Dates". The column in the table is a Date/Time column and is sorted in date order, Lowest to Highest, and when any new dates are added to the table (through another form) they re-sort into date order.

The "Date Select" form allows the user to highlight a date and open a record containing information logged against that date, however the dates on the "Date Select" form will not sort into the logical date order that the table that feeds it is in!

I've set the "Date Select" form Property "Order By" to [Datse_List DESC], (Dates_List being the name of the List Box on the form that displays the list of dates from the table), and set the "Order By On Load" to "Yes", but still the dates in the list box remain out of order.

Dates are entered into the table "Dates" column retrospectively / randomly.

Any ideas how to make the dates in the list box conform to Lowest to Highest please?? :banghead:

 

[CJ_London]

[Datse_List Desc] should be the name of the field in your recordsource.

If Desc is not part of the name, you should have it outside the square brackets

[Datse_List] DESC

 

[Frankie_The_Flyer]

Thanks CJ! I'll try that, but I also had a better think about it and linked the form through a sorted Query which works well.
Cracked it two ways!!

 

[CJ_London]

Just noted you are referring to a listbox - in which case you need to do the sort in the rowsource to the listbox

 

[namliam]

Dont want to be a pain, but why use a list box and not i.e. a date picker control ?

 

[CJ_London]

I think the OP only wants to list certain dates where events have happened.

Not sure if he is using a continuous form or a list box, his post refers to both