Link to home
Start Free TrialLog in
Avatar of howcheat
howcheatFlag for United States of America

asked on

Combo box with Months to retrieve monthly data between first day and last day of month

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?
SOLUTION
Avatar of GRayL
GRayL
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SQL... GRayL... no chance for me to score then.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks, just curious, did you try my approach?  You seem to prefer two extra hidden textboxes, two functions and a sub with a mile of code over an additional combobox and no functions or subs?