Between Dates

[Sadukar]

Hi.
I am trying to create a report that pulls data from a table without using a query.
I want to attach the code to a button on a form.

The report has to be compiled between two dates from one field.
eg. I want a msg box to ask between which dates I would like the report.

Any sugestions would be appreciated.
Thanks,

Sadukar

 

[ajdesalvo]

Add 2 text control boxes for the dates on the form. Add a command button with the following code:

DOcmd.OpenReport "YourReport", acViewPreview, , "[RecordSourceDateField] Between #" & Me![FormDateField1] & "# AND #" & Me![FormDateField1] & "#"

Good luck! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"