Date format prob I think?

[markvan]

I am passing a date from the previous page, and am filtering the recordset for the current page by that date,
I get this error:

ADODB.Field error '800a0bcd'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/equip/eccreport3.asp, line 203

Basically the results are empty, no records, but I know there is!
When I test the recordset I get this:

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression

How do I correct the data type ?Date Format? so that it recognises it and gets the records?

This is the last step in what has been a mammoth learning curve for me, this solved will complete my app.
s-) Thanks in Advance s-)

 

[Cheech]

Make sure that all places you can define the date are the same format in Access & Ultradev Live long and make your kids suffer..