That doesn't work, you'd always get circular references. Instead you need to
write VBA or VBScript code for that.

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool:
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Thu, 29 May 2008 12:02:03 -0700 schrieb Scuff:

Hello - I work for a private foundation and am trying to include a formula
on
our contact form. I want it to do this:

Field 1: amount of most recent grant (i.e. $10,000)
Field 2: total amount of grant $ received (i.e. over multiple years)

so I want Field 2 to automatically update from Field 1. When I put in a
new
amount in Field 1 (i.e. most recent grant of $50,000), I want this amount
added to the total in Field 2...so far I have tried lots of different ways
of
approaching this, including having some 'hidden' fields, but no luck. Any
suggestions would be much appreciated!!