Macros, Queries, Parameters

[Databaseguy]

We've got a month end routine that prints a bunch of reports. I just modified the reports to take input parameters (Start Date, End Date). Can I pass an argument to the parameter via a Macro ? Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[nickjar2]

Create a form with 2 text boxes and a button.

If your form is called form1 and your text boxes are called text1 and text2 then place the following in the query for each report:

Start_Date End_Date
forms!form1!text1 forms!form1!text2

Hope this makes sense,

Nick