Custom Forms - formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scuff - 29 May 2008 20:02 GMT

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

Reply to this Message

Michael Bauer [MVP - Outlook] - 30 May 2008 06:50 GMT

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

Signature

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:
[quoted text clipped - 7 lines]
> approaching this, including having some 'hidden' fields, but no luck. Any
> suggestions would be much appreciated!!

Reply to this Message