using FindFirst with a Date Criteria (syntax error)

[ajetrumpet]

all,

I am getting a syntax error on the findfirst line here:

dim sDate as Date
sDate = "5/5/2005"

'OPEN TABLE
rs.MoveLast
rs.MoveFirst
i = 0

      'LOCATE STARTING POINT
      rs.FindFirst "[orderdate] => " & sDate

I'm not fond of using dates in anything. I have no idea how to get rid of the error. The syntax error is missing operator. The formats for the date variable I've tried are:

#5/5/2005#

I have also tried variations of the findfirst line:

rs.FindFirst "[orderdate] => #" & sDate & "#" (when variable is in quotes)
rs.FindFirst "[orderdate] => #5/5/2005#"

I have not tried the findfirst line with (). Can I get suggestion here as to what to try next? I have tried the importing routine to check for corruption. That did not correct the problem. thanks!

(I think access might be evaluating the data variable "/" signs as arithmetic operators. that would make sense with the warning messages. that doesn't shed any more light for me though!).

[ConneXionLost]

VBA is always fickle with dates.

If you have a numerical field in your table, can you test your code with that? If it works, then you'll know it's the date that is giving you the grief.

Cheers,

[ajetrumpet]

it wasn't, it was da** OPERATOR. it doesn't accept =>. But it does accept >=. what are the chances? i'm sure it was my fault again.