September 28, 200421 yr I have a field that is an auto-enter calculation. When I create a new record, it automatically calculates it. The problem is that the calculation is based on info that will be added to the record. How can make sure that the calculation gets fired again? Thanks! John
September 28, 200421 yr Author Nevermind. I should have looked in help before posting. Here is what I found: If you select Calculated value, you can edit the field value in Browse mode (if Prohibit modification of value isn't selected). The value is calculated when you create a record, or when one of the referenced fields changes and the destination field is empty. However, if you select Do not evaluate if all referenced fields are empty in the Specify Calculation dialog box, the value isn't calculated when you create a record and all fields referenced by the calculation are empty. Instead, the value is calculated when one of the referenced fields contains a value I just had to uncheck the do not evaluate option and it worked. Hopefully this will help someone else. John
September 28, 200421 yr Auto-enter works only upon creation. For automatic calculation, use a calculation field.
September 28, 200421 yr In version 7 auto-enter works every time a record is modified, if you deselect the 'Do not replace existing value' option.
Create an account or sign in to comment