combo box in form to pull report based on month

[CRobledo]

I need help, I have a form that I want to make where you select a month from a combo box "Jan, Feb, Mar ect" and the click on a command button to preview a report based on the month selected. The records are imputed in a table named "Sales imput" in the format of mm/dd/yyyy for every day on the year one record per day. I already made the report but it displays all the records for all the months its named "Monthly Sales rpt".I just want it to display all the records for the selected month.



if anyone has done this please let me know

[ranman256]

make a tMonth table:
1, Jan
2, Feb
etc

use this table in the combo box, show col 2, hide col 1, via columnwidths=0;1, and set the bound column = 1
it also seems you will need a text box for year , txtYr (unless you are going to report on 1 year only)

the query for the report will then pull data looking at the form items
select * from table where month([MyDate]) = forms!myForm!cboMo and year([MyDate]) = forms!myForm!txtYr

[CRobledo]

sorry, I guess I should of specified I wanted the report to be filtered not necessarily make a query. I got it to do it for just selecting one record and print preview the selected report but I also want it to be able to print preview the report for all the dates in a months. I attached some screen scaps so you can see what I did.

[orange]

You may get some ideas from this material by Martin Green Dynamic Reports.