filter by year (1 Viewer)

tubar · Nov 18, 2019

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

Code:

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

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

Code:

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 · Nov 18, 2019

What happened to the
= True?

theDBguy · Nov 18, 2019

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