Trigger macro

[#1]

I am tyring to trigger a macro when changing a cyclic group. Does anyone know how to do that? Appreciate any assistance.

[Anonymous]

There is no trigger for that.  I suggest using a button instead of cycling group, so the button would cycle through the fields - and trigger a macro.

Regards,
Michael

[Gysbert_Wassenaar · Accepted solution]

Create a variable as =getcurrentfield([GroupNameHere]) and add the Run Macro action on the OnChange variable trigger.

[Anonymous]

Looks reasonable, worth trying for sure

[#5]

Perfect! Thanks!

[#6]

Hi Gysbert,

This suggestion woked. But I had to create a text box with that variable and hide that text box. I don't know why it needs that text box, but it worked only with that. While testing, I realized that once you clear, and then change the cyclic group, the macro was not getting triggered unless the text box is always set to "show". If I set the view to 'Conditional', it works only the first time you open the application. Please let me know if you have any thoughts as to why this is happening.

Thanks

[jerrysvensson]

I have seen similar problems.

Try to put your textbox in a sheet that you then hide. That usually works.

[#8]

It didnt work. Thanks anyway.