Marcia, I tested the value in the debugger when I got the error and it is Ok.

>anyway the fact is that i get the error DataTypes mismatch when 'm not sure it is not the case !!!

I wrote wrong because i am sure it is not the case

Moreover, how could you explain the fact that i got no error if I select the table with the wanted order before i perform the seek ?