Please see the attached database. Jez created the form frm_KPI_Main.
As you can see the MonthID is a text field and the order field is used to sort them into the correct order. I am going to be adding some buttons to launch some reports directly from this form and I want to use the Month ID as the search criteria in the query.
However the date combo box doesn't return what is selected (i.e. December 2010) but it returns the order (01) - Is there a way around this?
Also is it possible to arrange the dates into descending order?