Filter subform from main form
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!