Open a report bases on a form

[peterbowles]

I want to open a form based on two dates.

I have a dlg box where I enter
1) start date
2) end date

When I press enter I want a report to come up that shows records between the dates I enter

How do I do this?

Thanks

 

[KenHigg]

Base the form on a query and use the text boxes as pararmeters.

???
kh

 

[shirin]

As the previous person said, create your form based on a query with the date criterias as:

Between [Enter Start Date] And [Enter End Date]

Then on your form create a text box with the following in its Control Source:

="From " & [Enter Start Date] & " Through " & [Enter End Date]

Hope this helps!