Date Range form issues

[msuguy71]

Hi all,



I have a problem, and I am not sure how to address it. Here are the issues:

I wanted to create one form for entering a date range (start & end dates) for any reports that I would need a date range. I created a date range form using unbound textboxes. I read that the date range form had to remain open so that the dates could be passed to the report. So, to address this I have my report open the date range form on report open, then I created a "run report" button and a "cancel" button on the date range form. On the run report button I created a macro (using the macro builder) to open the report, and then close the date range form.

Here is the problem. I have to create a new date range form for every report I want to search based on a date range because of how the macro builder selects the report to open (it doesn't know that I ran a specific report).

Another problem is that I created a second report which was similar to my first one but the query is different because I was getting an error, but on that report, I can't pass the start and end date parameters (using the update parameters in the macro builder) like I could with my first report. So, when I run the second report, the date range form opens, I enter my dates, hit run report, the date range form closes and the generic parameter box appears wanting me to enter a date. Everything is the same except I can't pass the parameters because that section doesn't open on the macro builder.

I know that what I am trying to do is not proper database building with regard to the date range forms issue. Anyone able to help me out?

I included my database in this post.

Thanks,

Rick

[June7]

For starters, recommend not using dynamic parameters in query (I never do). Instead use the WHERE condition of OpenReport.

The report name can be passed to the date range form with OpenArgs argument of OpenForm. Then code in date range form can read its OpenArgs to extract the report name to 'know' what report you want.

I use only VBA and this is all very easy in VBA. Not sure about macro.