Getting Dates in Combo box in calendar order

[cms2012]

Hey everyone,

I have a combobox that lists the months in a year. They are being pulled from a query and are formatted like January, February, etc. The problem is that they are being listed in alphabetical order and I want them to be listed in chronological order as they are in a calendar.

If someone could help me I would be greatly appreciative!

Thanks

 

[MarkK]

Do you want to display all the months all the time? Then there is no need to draw this data from a query. Change the RowSourceType property of the combo to Value List, and change the RowSource property to ...

January;February;March;...;December