Save Data from a Calculated Control to a table

[kramsey]

I have created a calculated control in a form which gives me the total of items purchased. How do I send the total to the underlying table to be saved?

 

[PennWhite]

Ramsey - Same problem. Did you ever get (or find) an answer?

Thanks,

Penn

 

[PennWhite]

I did find this and it may be the only way. Seems like there could be something a lot simpler but maybe not. - Penn

http://support.microsoft.com/?kbid=209172

 

[PennWhite]

More info:

Question:
"How would i go about saving the data in a calculated textbox on a form into a field in a table?

For example, on the form there is =[MatchedPages]+[UnmatchedPages] that I put into a textbox. I now want to store those results in a table with the field titled TotalPages. How would I do this?"

Answer:
"It is a good rule not to store calculated data in a table.
It needlessly takes up space and in some cases may cause invalid results.

Calculated data can be generated anytime on forms, reports and in queries.

This question has come up many times in this forum, and the answer (from the profesionals) is always the same."

 

[PHV]

Take a look here to better understand why it's often a bad idea to store derived/calculated values:

http://www.abcdataworks.com/fundamentals.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244