help with applyfilter

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

Guest

I am using cbo box after update event to filter my records on a form by period

if the condition is:
[Forms]![EXPENSE REPORTS BY PATIENT]![TRAVELDateFilter]="2007"

then the action should be : apply filter , where condition = [travel] Like
"*/*/2007"
i have 7 conditions for the years from 2001 thru 2007 .

it was working ok , but with the beggining of the new year it stopped except
with the current year which is the same example givin above. what is the
problem.

what i want is to show the records with travel date for the selected year
only.
 
It should be where condition = Year([travel]) = 2007, or where condition =
[travel] BETWEEN #01/01/2007# AND #12/31/2007#
 
Back
Top