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

Try using a calc instead of a summary

Sum(DB Name::Your Field)

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

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