Combo Box On Rport to Filter

[angie]

I have a report that is generated from a query. It filters the report by “date” that I have to type in each time I run the report. I would like to place a combo box on thereport so that you could select a month “January” “February” so forth. The dateis entered as 7/1/2016 not by July, 1, 2016. So the combo box would have toconvert the month from number to text and then filter by month that youchoose. Thanks Angie

[ranman256]

you put the combo box on a form, select the month in a combo box and open the report based on that.
in the combo afterupdate event , add some code to fill in the start and end date text boxes.

txtStartDate = cboMonth & "/1/" & txtYear
txtEndDate = dateAdd("d",-1,dateAdd("m",1,txtStartDate))


then the query is:
select * from table where [DateIs] = between forms!frmRpts!txtSTart and forms!frmRpts!txtEnd

[angie]

Where do I enter the Code?
I do not understand what you want me to do after making a form and adding a combo box.