Dynamic Choices for Dialog List based on value of another field

I’ve got a field (call it A) and a dialog list field (call it B). Depending on the value of A, the choices in B can be different. I’ve used @Formula to determine B’s list, e.g. if A=fruit, then B={apple, orange, banana}; if A=candy, then B={caramel, licorice, mint}. I’ve tried using lotusscript refresh code in the Exiting function of field A, however this does not refresh the list options of B. F9 in the doc does not update B’s list options either.

Thanks for your help!

Subject: Dynamic Choices for Dialog List based on value of another field

You tried option “Refresh field after keyword change”? This is of field property, which will refresh the doc if this field is changed.

Subject: RE: Dynamic Choices for Dialog List based on value of another field

That didn’t work, however, the option below it, “Refresh Choices on Document Refresh” worked! Thanks so much!! EOM