How to edit calculated field in FORM

[Apple]

Can I edit an calculated field in my form if needed. Thank you in
advance for your help.
Sincerely
Apple

[dmkeith2]

Need more details. Usually if you didn't create the calculated field
in a query the calculated field is an unbound box.

You can insert an unbound text box and create a calculated field.

[Alan Webb]

Apple,
No. Think about Excel. If you edit a cell in a worksheet that had a
formula and your edit replaces the formula with a value then you've lost
that formula. You can fake it by placing code behind the form which
interacts with a text box and does your formula in the code behind the form
then puts the result back in your text box.

"Apple" <tt*********@yahoo.com.hk> wrote in message
news:55**************************@posting.google.c om...

Can I edit an calculated field in my form if needed.

[pietlinden]

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?

[Apple]

pi********@hotmail.com wrote in message news:<11*********************@f14g2000cwb.googlegr oups.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