filter by year

[tubar]

Im trying to filter my forms date field by year with a button.

Me.Filter = "year([date])='2019'"
Me.FilterOn

when i apply the code to filter by month it works fine.

Me.Filter = "month([date])= '10'"
Me.FilterOn = True

I even tried creating an unbound text field that displays the date field formatted for year and filtering that. any suggestions on a VBA fix

 

[Gasman]

What happened to the
= True?

 

[theDBguy]

Hi. I agree with Gasman. You forgot to assign True to Me.FilterOn. Did you get an error without it?