rst!Find First doesnot work if I use a "date" search criterion

[Jawad77]

I am trying to go to a particular record in my recordset and I using this line of code

rst.FindFirst "[Weekending] =" & 1/14/2005

and it doesn't take me to the current WeekEndingDate record in my recordset. I tried using:

rst.FindFirst "[Weekending] =" & #1/14/2005# but it doesn't work either.

FindFirst method works though When I change my search criterion to:

rst.FindFirst "[FiscalWeek] =" & 50

Looks like I am not using the right syntax when I use week ending date in my crietrion. Otherwise it works when I use a number in the search criterion.

Any ideas/thoughts? Thanks a lot in advance for your help

Jay

 

[FancyPrairie]

Try this:

rst.FindFirst "[Weekending] =#" & Cdate("1/14/2005") & "#"

or this:

rst.FindFirst "[Weekending] = #1/14/2005#

 

[Jawad77]

It worked. Thanks a bunch Fancy!