Filtering records Visual Basic 6 ADO?

Use a QUERY in Access, and make the query read the datepicker controls - put the following in the CRITERIA cell for the date: BETWEEN FORM1!dtPickerStart And Form1!dtPickerEnd, then base the REPORT on your QUERY