By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

How to edit calculated field in FORM

P: n/a
Can I edit an calculated field in my form if needed. Thank you in
advance for your help.
Sincerely
Apple
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a

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?

Nov 13 '05 #4

P: n/a
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
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.