I have a field event (on select) trigger for a field (YTD) that changes several variables. It works fine when I make a selection from a list box in the "YTD" field.
However I also set up a sheet trigger that "Selects in Field" so that when I enter a certain sheet it makes a selection in the YTD field. But this does not change the variables like it does if I select the field directly from a list box.
I think you are correct - the trigger does not fire when the field selection is set with an action. You may be able to do this in a macro - but another option would be to define the variables differently.
If the variable is defined as an expression with a leading = sign, it will be re-evaluated automatically when the selection changes - removing the need for the first trigger and making the second trigger work correctly.
I don't know what you have in your variables, (can you provide more detail), but by way of example, if the variable is defined like this:
Set vMinDate = =Date(Min(InvDate));
If you create a text box with the expression =vMinDate, then you will see that the value changes immediately when you make a selection that affects the minimum value of InvDate.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
