Option Group And 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 and the combo box is used to filter the year.

Thanks for the help.

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

 

[theDBguy]

Hi. Welcome to AWF!

Should be just a matter of building a Filter string. For example:

strFilter = "Month(DateFieldName)=" & Me.OptionGroupName
Me.Filter = strFilter
Me.FilterOn = True

Hope that helps...

 

[Nightfire22255]

Thanks for replying!

I figured how to do the option group. I just don't how to use the combo box(which chooses the year to filter) in conjunction with the option group.

Any tips on that. Thank you though.

 

[theDBguy]

Thanks for replying!

I figured how to do the option group. I just don't how to use the combo box(which chooses the year to filter) in conjunction with the option group.

Any tips on that. Thank you though.

Okay, you could try it this way.

strFilter = "DateFieldName Between DateSerial(" & Me.ComboName & "," & Me.OptionGroupName & ",1) _
    & " And DateSerial(" & Me.ComboName & "," & Me.OptionGropuName + 1 & ",0)"

Hope that helps...