I have a Variable macro called 407ETR-Mthly.

1] The macro picks up user supplied data ( dates )
then returns with a query list based on the above dates ( lower/upper limits
).

It looks like this:

'Create-date' >= "$What START date ?$" AND 'Create-date' <= "$What END date
?$"

Once the daytes are supplied properly by the user, the Macro runs just fine.

2] However when I attach the macro to a button and run it with an Active
link,
an error message pops up complaining about the date format.

3] I want new users to run the macro by clicking the button;
what am I doing wrong ?

Is there a better way ?

Pls help

Alex

When you run a macro from an Active Link, you have to specify the values
passed to the macro, which can be fields on the current form. What did
you assign to the parameters and, if you specify fields, what type of
field are they?


-----Original Message-----
From: Alex Mireku [mailto:AMireku@407ETR.COM]
Sent: Friday, December 29, 2000 10:30 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Macro cannot run

I have a Variable macro called 407ETR-Mthly.

1] The macro picks up user supplied data ( dates )
then returns with a query list based on the above dates ( lower/upper limits
).

It looks like this:

'Create-date' >= "$What START date ?$" AND 'Create-date' <= "$What END date
?$"

Once the daytes are supplied properly by the user, the Macro runs just fine.

2] However when I attach the macro to a button and run it with an Active
link,
an error message pops up complaining about the date format.

3] I want new users to run the macro by clicking the button;
what am I doing wrong ?

Is there a better way ?

Pls help

Alex