Parameter / datatype

[dl41001]

I have a bunch of queries put in 1 macro. Of course, some queries have the same parameter [Enter current monthend] so when I run a macro, there are few popups asking to [Enter current monthend]. It’s annoying for users to put in the same parameter 2 or 3 times for a report. Is there a way to avoid it?


I tried to make [Enter current monthend] as a new_field so the 2nd query could pick up new_field instead of [Enter current monthend] again but that gave me an error b/c the new_field automatically has ‘binary’ datatype instead of ‘date’ datatype. How can I fix this?

Thanks.

 

[neileg]

Capture the parameter in a form instead of a prompt and you can point all of your queries to that. Instead of the prompt in the query grid, use this syntax:
Forms!MyFormName!MyControlName