>field1 is a date, and the contents of the two variable are two dates dor example:
>
>variable1: 01-01-2000
>variable2: 31-12-2000
>
>I want to select all the records betwen this two dates.
>In vb i set the two varibles as strings

Try this one:

rst.Filter = "field1>=#" & variable1 & "# AND field1<=#" & variable2 & "#"

After the filter is set you should have a lower recordcount, and you can loop to EOF() with only the rows that match the filter. If you have an error message, be sure to include it on your response.