View Full Version : Calculated field


matt123
05-31-2002, 12:39 PM
Dear All
I have a If Then, Else If contstruct in the AfterUpdate control of one field(Weight) which determines the default value of the next field(Calulated Price). The user does not always know the value of Calculated Price because it is really a suggested price. To be clear( I hope): Calculated Price is based on the Weight, with a minimum and a maximum. In most cases the user does not know the price, but on certain occasions he does. So the If Then Else If determines the suggested price, but the user can override it if necessary. Is this sound design? Would appreciate any suggestions.
Thanks

llkhoutx
05-31-2002, 10:53 PM
Use nested iifs, checking a field where the user has specified the price.