Entering Paramters for Reports opend from a form.

[peters]

I have created several reports that use the same two paramters [Start Date] and [End Date].

I am in the process of creating a form from which these reports can be launched and the paramters only have to entered once.

I set-up to unbound boxes and named them Start Date and End Date, enter the date and then when I open my report, I am promted for Start and End date link normal.

How can I get the report to understand to use the Start Date and End Date from these unbound boxes?

Or, do I need to be doing this a different way?

Peter.

 

[NightPort]

Have you linked the Report to the form?

 

[Fornatian]

You will need to explicitly reference them to the form that you are on, suchas:

Forms!MyForm!StartDate
Forms!MyForm!EndDate

This will make sure it pulls the info from the form and not ask you form criteria.

I tend to base these types of reports on queries instead because at least then I can see what I've done easily.

Ian

 

[peters]

Awesome. All I had to do is change my query parameters statemet (which the reports are based on to:

Between Forms!FormName![Start Date] and Forms!FormName![End Date]

And it worked.

Thanks Fornatian. You have now openned the door for me to create some nice easy to use menus (using forms) so my department can easily use the database I have created.

Peter

 

[Fornatian]

Your Welcome, Happy Hunting!