update values for new formula field

update values for new formula field

I added a formula field to a form with existing data. How do I update this field for all existing records.

I'm considering adding a temp field and doing a bulk edit to change the temp field and then remove the temp field. This would force a recalc of the formula field. Is there a simpler method?

Herb Wexler
www.PreventingMediocrity.com