Hi All

I would like to know an Auto-calculation field can be changed? It means that a field (auto-enter calculation) take value from other field at the first time. But when The other field changes the value the field (auto-enter calculation) does not change ...it remains still ... I want that auto-entet field changes also not using calculation field ... Is there a way to achieve it?

Thanks

Anh Tran

Once the calc has triggered it is from then on a normal field. Nothing can force it to recalculate. That is the whole point of the auto-entered calc.

What you migh actually be looking for is simply a stored calculation.

If you want the field to change when the other field changes -- or, in other words, if you want the value of the field to be dependent on the value of another field, then you want it to be a calculation field. That's what a calculation field is for.

You might also check out the latest version of my attached file under Handy Bits in the Samples Section of this forum - probably on page 2 by now... There is an example in that file of over-riding a calculated result.

Make sure you go to the end of the Handy Bits thread to get the latest version (version 4).

HEllo Kurt,

You are right I need a stored calculation to make the relationship.

Hello Russbaker, I did try to download the handy bits example (version4) but I did not see anything in it ...i see a list of weird characters.

Can you check it?

Thanks

Anh Tran