Rico
|
| Posted: 04/28/2002, 3:28 PM |
|
Help please...I have a payment form with three list boxes (monthly_renewal, late_fee and reconnect_fee). I would like to have the form calculate a total based on info entered by agents.
monthly_renewal, late_fee and reconnect_fee each pull values from their own table in the database.
If the agent enters:
monthly_fee = 49.95
late_fee = 10.00
reconnect_fee = 24.95
I would like the form to be able to automatically calculate the "total".
Thanks in advance for any help.
Tried the "fldtotal= fldmonthly_renewal + fldlate_fee + fldreconnect_fee" in the "Before Show" Event but it did not work.
|
|
|
 |
Nicole
|
| Posted: 04/29/2002, 6:30 AM |
|
Rico,
once fldmonthly_renewal, fldlate_fee and fldreconnect_fee are displayed as numeric values on the screen they could be used in calculation. Try to print the value of fldtotal in Before Show event. Is it empty? If yes, try to use type cast, e.g.: Cdbl(fldlate_fee)
|
|
|
|
|
