Excelente Avellaneda me quedo de esta forma:
Código:
rs.Open "SELECT * FROM Contratos WHERE termino " & "BETWEEN #" & Format(TxtFechaIni, "mm/dd/yyyy") & "# " & _
"AND #" & Format(TxtFechaFin, "mm/dd/yyyy") & "# " & _
"ORDER BY termino", cnn, adOpenStatic, adLockOptimistic