Nov 14 2021 03:07 PM
Hello,
I have a macro
I didnt design it
I run the parameters On Open of a report.
I need to modify (add another parameter) it but I dont understand parameters too much.
There are 3 rows and I want to add another.
I have rt clicked and searched all over and cant find how I do this.
There is a hyperlink "update parameters" but that doesnt do anything other than hide all of the parameters.
Grateful for the help.
Nov 16 2021 08:15 AM
@Tony2021 This is hard to explain via this environment, so use your imagination a bit in looking for answers.
Apparently there is another macro involved. That macro is associated with the report and that is where the parameters should be defined. Look in the report and see what you can find. If you find such a macro, show it here and we'll see if we can pursue it.
Nov 17 2021 10:03 AM
George,
I see one saved macro and within the report are the parameters.
I see I can add an action but there are many options.
Do you know which action it would be?
Nov 17 2021 05:51 PM
I had to review macros. I almost never use them and it had been a long time since I did.
Open the query that provides records to the report. It should have three parameters already, the ones shown in your screenshot. Add the fourth there. Now, when you edit the macro and click on the "update parameters" link, it should add the fourth parameter.
Hopefully that'll do it.
Nov 18 2021 08:24 AM
Nov 19 2021 08:06 PM
Quoting myself,
"Open the query that provides records to the report. It should have three parameters already, the ones shown in your screenshot. Add the fourth there."