Need a trick to change field selection values
Posted on 2004-10-26
In a form, there is a field called Options: Checkbox, editable, formula for choices is AllOptions, and both Refresh fields and Refresh chocies are selected. The formula in the CfD-field AllOptions is
@If(Options="Ma"; "Send as mail | Ma":"Send on Save | Sd"; "Send as mail | Ma")
What I want is that, if the user selects the Send as Mail option, a second option is displayed, namely Send on Save. This works... almost, I only have to press F9 to make it show up.
Calling Refresh from the PostRecalc is illegal, but would be the solution if it weren't recursive. I already tried to put a GoToField("nextfield") in the Entering of the Options-field, but this effectively blocks the user from doing anything in that field. Which is by all means a great feature, but not for this purpose (equivalent to using InputEnabled, but works in R5 as well :).
How can I do this using more or less standard stuff? I think I know some ways around this, but your tricks are welcome!