Find recordset using date field problem

[millrat]

Hi all,
I am trying to find a record on my form using the code below but I keep getting errors. Depending on how I move the quotes etc around I get different errors, sometimes data type mismatch, other times syntax error, missing operator. Now I'm confused, is it the syntax or the datatype?

[dtmDate] is the field datatype Date
Me.cboDate is textbox control source [dtmDate]

Dim rst As DAO.Recordset
Set rst = Forms!frmLog.Recordset.Clone
rst.FindFirst "[dtmDate]= '" & Me.cboDate & "'"
If Not rst.EOF Then
Forms!frmLog.Bookmark = rst.Bookmark
End If
End If

Any help appreciated
millrat

 

[Remou]

Hi
Dates need #.
[tt] rst.FindFirst "[dtmDate]= #" & Me.cboDate & "#"[/tt]

 

[RoyVidar]

Remou is correct, but sometimes you'll need to take it a step further - that is if you're on other date settings than US - have a look at International Dates in Access for more info.

Roy-Vidar