How To put a calculated filed value into a table

[spam]

On a form, I have a calculated value. How can i get this value into a table that I have created?

Thanks

 

[RickSpr]

There are several ways to do this. Which one you would use depends on where the calculation expression exists: in the control source, in an underlying query definition, or in code.

Consider whether you should really do this, though. If the value can be calculated whenever it's needed, it's usually better to do that than to store the calculated value. If you avoid storing it, you don't have to worry about recalculating and updating if one of the values it depends on changes.

But if you're sure you want to do it:
Is the form bound to the table you want to update?
Where is the expression that calculates the value? Rick Sprague

 

[spam]

Yes, im sure I want to do this. The reason
is that I have a table that list 2 products and the prices
associated with the.

I have created a form with combo boxes where you can select
individual products and depending on the selection, the unit price is displayed. On the form I also have a text box that displays the sum of both products. This works fine.

But when I go look back at the table, only the product description, and its unit price is displayed and I cant figure out how to have the sum of both products visible in the table.

Any suggestions on how I should do this?

Thanks in advanced for your help....

 

[Calator]

Spam,

This question had been asked recently by Kaniz "storing calculated fields on a table" thread 181-56781
Come to

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/181/qid/56781

to view.