pi********@hotm ail.com wrote in message news:<11******* **************@ f14g2000cwb.goo glegroups.com>. ..
Apple wrote: Can I edit an calculated field in my form if needed. Thank you in
advance for your help.
Sincerely
Apple
Only if you do something like calculate the value and insert it into a
field when exiting another field (in other words, you'll need code to
do it.) What are you trying to do? Make a calculated default value or
something?
Hi, Thank you for all of your reply. Let me explain my situation. I
have a receipt to charge customer & received payment (No more
invoice). I have 4 items to be charged, and each receipt charge one
item only. 2 items have a fixed rate (will be revised within a period)
& 2 items without fixed rate. So when I select the fixed rate items,
the calculation of [itemVaule} * [PayPeriod] can be workable. But in
the items without fixed rate, I hope I can put the [Total amount] by
myself. In addition, I need all the above to generate a report. Hope
the above will give all of you a right director to think of my
problem. Thank you again for your help.
I had tried to calculate in query by using an expression : [ItemValue]
* [PayPeriod], but the result is can't edit the [TotalAmount} field in
FORM.
When I had tried to use an unbounded test box in FORM and make an
equation in ON CURRENT EVENT - Me.TotalAmount = Me.ItemValue *
Me.PayPeriod, it can edit the [TotalAmount] field, but it can't save
it, I need the [TotalAmount] to generate report.
Sincerely
Apple