I have a read only subform on a main form. The subform has a few hundred records with a particular field called txtInvoiceDate which holds a date,(medium date format).
The records on the subform, are over the course of a whole year.
With 12 command buttons on the main form (one for each month), i would like to filter the subform into one particular month for that year, using one of the command buttons on the main form that corresponds with that particular month.
Any help would be appreciated, Thank you!

Create an SQL statement for whatever is selected, set the recordsource for the sub form to be that SQL statement, then requery the subform. (or refresh)

John

John thank-you very much for your response, it's worked very well.
I simply made a command button that when clicked, put my SQL statement
on the recordsource property of the subform. For my intent and purpose, works like a charm.
Thanks again!