Multiple Dropdowns on form to select Month and sort Order

[mindbender]

I have a combo box that contains the 12 months of the year and one for Sort order. What I would like to happen is the users Selects January and then Ascending and the data returned is January Data sorted Ascending. If they Choose March and Descending the data returned is March Data sorted Descending.

Losing my mind trying to figure this out.

Any help would be awesome

Thanks

[June7]

I would use VBA to set the form Filter and OrderBy properties.

Here is example to set Filter. http://www.allenbrowne.com/ser-62code.html