Simple Q. But pls answer.

I am using VB6, Access XP and CR8

I have a table in Access which there are thousands of records.
But I want to display in CR8 filtered records falling between two dates.
I want that Access should return only that many rows that are required to display in the report.
The user will select the date range. And I want to pass the two dates to access so that it returns only that many rows.

Which technique should I follow ?

I have been using the Crystal Report Control.
And calling the report this way.

With CrystalReport1
.DiscardSavedData = True
.ReportFileName = App.Path & "/Invoices.rpt"
.Action = 1
End With

Please suggest.