How do you do a findfirst with a date/time value

[Pack10]

What is the proper way to do a findfirst or a dlookup with a date time value. For instance, if I have a value 06/27/2011 11:27:18 AM.
How should the findfirst be coded... Mine sometimes does not find the record and I know it's there.

 

[lameid]

What is your code, what are the datatypes of the involved fields?

 

[Pack10]

Field data types are date time, the value that the user selects is
A date time value. The find and the dlookup are not locating the record while I know it's there. This is a date time that I am
Trying to pull from the tables. Should I be using seek.

 

[SkipVought]

Code, Code, Code!

It was requested and you ignored!

CODE PLEASE!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Pack10]

I got it to work by basing it on this code....

rs.FindFirst "DateValue([YourDateField]) = #" & Format(Dates.DateOfBooking, "yyyy-mm-dd") & "#" & _
" And TimeValue([YourTimeField]) = #" & TimeValue(Dates.TimeOfBooking) & "#"

 

[PWise]

how about


"DateValue([YourDateField]) = #" & Dates.DateOfBooking & " " & Dates.TimeOfBooking & "#