allow a user to override a calulated field

tbcwarrior

Registered User.
Local time
Today, 06:08
Joined
Oct 10, 2006
Messages
26
allow a user to override a calculated field

Hi all

i have a field called commitment fee and it has a calculation of
=-IIf([Type of finance]="Term Loan",-([Total amount requested]*0.015),-([Total amount requested]*0.01))

but i want to allow a user to enter a manual amount of money into the field how do i do this.

regards
chris
 
Last edited:
One thought:
Set the value of your field in VBA code on the 'After Update' event of the three fields.
 

Users who are viewing this thread

Back
Top Bottom