Sorting a List-Box

[joesmithf1]

Hi,
I created an Access form with a list box. The "row source type" is from Table/Query. My source table is sorting correctly(ie, 2008,2007,2006, etc.). HOWEVER, when I open my form, the sort order is incorrect; they are not in the 2008,2007, 2006, etc. order.

Please advise how I can fix this. I looked everything.

Thank you.

Joe

 

[pbaldy]

Your row source should be an SQL statement that explicitly orders the data. The order of records in the table can not be counted on.