problem selecting date

I trying to goto a record matching a couple criteria, one of them the date but I keep getting this error:

"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

I'm working with an .adp file. This is what I have:

Dim lrs As New ADODB.Recordset
Set lrs = Me.Recordset.Clone

lrs.Find "[PondName] = 'Yuch-001' And [SampleDate] = #8/3/2002#"

Me.Bookmark = lrs.Bookmark


I'll replace the values 'Yuch-001' and the date with values from a combo box. This all works fine in Access. Any help is appreciated.

Thanks,
Doug in Fairbanks

I'm a little surprised I didn't get any responses to this question. I got a bunch from one guy over at DevX.com on this topic. But the problem is still unresolved....

Since this is posted on the SQL Server part but you are working with .adp file I don't know if this would be relevant. But you don't use # # sign around dates in SQL Server. SQL Server uses ' '

lrs.Find "[PondName] = 'Yuch-001' And [SampleDate] = '8/3/2002' "

But since I am not familiar with .adp files I don't know if this is useful.