I have a question... how can I know if my rs don't find anything, I'm sure that the record that I try to found exist, but maybe access can't find them.
Also I see that the problem occurs in the Date statement in SQL, when I delete the Date on SQL statement all work fine, so from this is the problem I try to only filter by date but the same problem occurs.
SELECT * FROM tblTarifas WHERE tblTarifas.Fecha = #01/05/2003#
too simple, but an error appears, I see that the record exist but I thing Im put some wrong on SQL.
first of all check if your date field has time information in it. if there is time information in the field comparing to plain date would return no results.
actualy #01/05/2003# = #01/05/2003 00:00:00#
you can check your if your recordset is empty 2 ways:
if rs.RecordCount=0 then YourRecordsetIsEmpty
if rs.EOF then YourRecordsetIsEmpty
#2 option looks weird but if your recordset points EOF when you open, it is usualy means there is no record in the recordset.