Calculated Control

Anyone know how to store the value of a calculated control in a table? Could really use that ability when it comes to doing a search. Thanks in advance

I have had the same reasons for storing a calculated field. The derivation of the final result is pretty complex such that it slows down my application to calculate this particular field when doing searches or reports ...

Create a field for the calculated control in the table the form is based on. Set the control source of the calculated control on that field. Most critical, before exiting the form (however you do that) ensure you do a save action so the calculation (or, in my case, the updated calculation) is saved into the field.

-dK

How do you invoke a save action. You mean simply click the save icon?

Could be. I am not sure how you exit your forms (or even if you use forms). For instance, if you have a command button on your form for closing the form or perhaps on an After Update/On Change event then you would use: DoCmd.RunCommand acCmdSaveRecord. You could place this after your calculation (if done in the VBE) to save the record.

-dK