Filtering data on a report

[jaijei17]

Hi everyone! I just need a bit of your help. In the production report that I made, I want to achieve 2 things.
1) I want the report to filter automatically to display only the current month's invoice. As you can see, all of the invoices are displayed from 2012-2014.
2) I also want to be able to filter the report based on the invoice number. I want this to be achieved by clicking the invoice button on the top part of the report.



kindly disregard the buttons client and date. im going to remove it already. Thanks in advance.

PS I dont have any good background with access. I just explored around it.

[ranman256]

Edit the query (the report uses) and put in the date field either :
1. hard code the date (bad)
2. put a parameter in the date field so it will ask the user the date: [Enter Date]
3. put text boxs on a form the report can read, and reference it by: forms!frmMyForm!txtDate