Option Group & Combo box Filter

[nightfire22255]

Hello all,

I need some guidance on filtering a subform with an option group and a combo box

Basically, I want to use an Option Group of months. When I choose what month, it will filter my subform to those month's records and the combo box is used to filter the year.

I'm still quite new to VBA. Thanks for the help.

From the screenshot, I'm filtering just from one date in the record.

[ranman256]

In the query add 2 fields: year([datefld]) and month([dateFld])

under the criteria put:
for month: forms!fMyForm!fraMonth
for year: forms!fMyForm!cboYear

(since i dont know the name of your form, i used fMyForm)

then afterUpdate event for both the combo & the fraMonth is: me.requery
so it can refresh with the new picks.