data1.recordset.findfirst causes GPF

[Z.J. Da]

Hi all,


When I use


data1.recordset.FindFirst "[Date] = #3/24/99#"


to find a record in database and the table does contain a record matching it, a gpf occurs with error msg "read 0x0000:0000" (no gpf if no record matching it). However, if I use MoveFirst and MoveNext to go through the table, everything OK. Any idea?


Thank you in advance!


Da

[Ahmed Saber]

Try
data1.recordset.FindFirst "format([Date],'dd-mmm-yyyy')= #24-Mar-1999#"