Subform does not return filtered and ordered records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Link fields is Description

In Sub Form
Filter= FORMAT$(chktran.CheckDate,"yyyy") >=2004
Order by= chktran.CheckNumber DESC

But it returns all records (all Years) matching description and in ascending
order.
Can anyone explain ?
 
The Format() function returns a string value.
ry taking the Year() of the date field instead i.e.:

.Filter = "Year([chktran].[CheckDate]) >= 2004"
.FilterOn = True

It is important to set the FilterOn property at runtime as well.
 
Back
Top