Problem matching recordset date to another rs date

[ChrisJohns]

Hi all,

Im currently having an issue with a recordset. Im trying to find a result in a recordset where the date matches that of a date in another recordset. I keep getting an error indicating that the datatypes dont match though. Ive tried using convert but its not been working right for me (maybe using wrong)

CurrentDb.OpenRecordset("SELECT max(SequenceNum) as newseq, NewName FROM tblDetails WHERE MoveDate = '" & rsMove![newDate] & "' GROUP BY NewName")

Any help is appreciated

 

[vbaInet]

If MoveDate is a date/time field then replace ' with #

 

[ChrisJohns]

doesn't work, although it detects the date now, it says no current record, dispite knowing that there is a record there :s

 

[vbaInet]

We need more information. What line of code is throwing the error?

I suspect you're trying a MoveFirst or MoveLast command when there are no records.