October 5, 200421 yr Hi, I have a drop down list of about 5 options.... how do I make it so that if the user chooses a certain option... option a, then the other field (money) will automatically be set to zero and cannot be changed? I tried going through validation but I may be misunderstanding that because it seems that it only validates that field on specified criteria, not based on another field. Thanks.. VANDY
October 5, 200421 yr Make money an auto-enter calculation of Case( field1 = "a"; 0; money ), and deselect 'Do not replace existing value for field'.
Create an account or sign in to comment