Using Access 2007. I have form that includes a list of race dates in format mm/dd/yy. I want to filter the dates to display all races run in a certain year entered in a field in the form header. I just don’t seem to know how to do it.
Form.Filter = "Year(DateRace)= 2019" 'This works , displays all year 2019 races.
Form.Filter = "Year(DateRace) = Me.YrRace" This blanks the form. Why?
Me.YrRace is a field where the user enters 4 digits for the year of interest.
Any help much much appreciated. Driving me nuts.