summary not updating

[Aussie John]

Hi I have a summary field which is a total of a calculation field.

The summary field only updates after closing the file and reopening it. I tried changing the storage options but I get a message telling me I cant change the storage options as the calcultion is based on a related field ( which it is). any ideas? thanks

[ktstem]

Try using a calc instead of a summary

Sum(DB Name::Your Field)

[Aussie John]

Thanks for that- but I dont get a summary total of all the records by that method

[QuinTech]

You can do this through a script which sets some plain ol' number field to the value of your unusable calc field, then base your summary off the number field. Just trigger the script through a button labeled "Recalc" or something.

Jerry