Multiple Parameterized Queries Run Together

[murre08]

Hi,

I have a several parameterized queries that I would like to run using the same information, but don't want to make the user enter the same parameters over and over again. What I envision is the use clicking a button to run a macro that will run each query and then open a report with the results of the query. This report will the output from for queries that require the user to enter the start and end date. Is there anyway, for me to have the user enter those dates one time and for each query to call that same information? I was thinking I could have the user enter the start and stop date into unbound fields on a form and then click the button, but I don't know how to call that information into the query parameter box. Any suggestions/examples would be appreciated. Thanks in advance for your assistance.

Cheers,
Peter

 

[boblarson]

Yes, use a form for entering parameters. In the criteria of the query you can refer to the form with start/stop dates by using:

[Forms]![YourFormNameHere]![YourControlNameHere]

And in the case of between dates it would be:

Between [Forms]![YourFormNameHere]![StartDateControlNameHere] And [Forms]![YourFormNameHere]![EndDateControlNameHere]

Or you can remove the parameters from the query and just open the report like this:

DoCmd.OpenReport "YourReportNameHere", acViewPreview,,"[YourDateFieldNameHere] Between #" & Me.YourStartDateControlNameHere & "# And #" & Me.YourEndDateControlNameHere & "#"

and that way you can do it in one place.

 

[DCrake]

Simple Software Solutions

Bob's solution works but is slightly restricted. Read the attachment to see if this is what you want.

CodeMaster: