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!!

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!!