select date range using a form

[THANOS]

Hi all!

I found the attached sample which is very usefull but I want to change it a bit so to select a date range directly on a query by choosing the dates on the form, instead of a report.

Can someone please assist me ?

 

[John Big Booty]

Firstly, Copy the Record Source from Report1, then create a new form and paste the Record Source you've just copied from Report1 into the Record Source for your new form.

Then either add a new button to open your new form or change the details of the on click event of the button that is already there.

 

[THANOS]

Thanks !!!