Combo box with Months to retrieve monthly data between first day and last day of month
Posted on 2007-08-01
I would like to create a combo box that will list the dates Jan 2006 - Dec 2007 and retrieve the data for the specific month from my query. For example, a user would click on Jan 2006 and the query would retreive all records from 1-31 Jan 2006. I have created a combo box with two fields, the first one is one through 12 (for each month of the year) and the second field in the corresponding month spelled out. I hid the first column and made it the bound column. I need to somehow associate this with the wrk_date field on my query. So ultimately, I want the user to be able to click a specific month on the combobox and retrieve all the applicable monthly transactions. And what do you do when you change years? Would you increase the size of the combo box and label Jan 2007 as 13, Feb 2007 as 14 and so on?