Multiple Parameter Entry! HELP!

[eskimododd]

I have written a Macro which uses the Output to function to export six queries to Excel. Each query has a 'Between' question for dates. At present I have to enter the start date and end date for each query which are all the same. How do I just enter the date once for all 6 queries?

Thanks!

MATT

 

[directormac]

Create a form with text controls where you enter this information. Have your queries reference these controls rather than asking for the info each time.

--Forming Mac

 

[eskimododd]

Cool Thanks - Will try it now.

 

[eskimododd]

That works! Just used the Command Button for the first time in a form to trigger the Macro.

Thanks alot! Major learning for me today!!

MATT