I won't rehash the 'don't store a calculated field' argument...that's a given.
But if you simply have to do this...use something along the lines of
=[ControlA] + [ControlB]
(or whatever your calculation is) in the Control Source of the Control in question (let's call it ControlC)
- Delete that from the Control Source
- Replace it with the name of the Field in the Table that is to hold the results of the calculation
- In the Form_BeforeUpdate event (in the code widow) place the following code
- Me.ControlC = Me.ControlA + Me.ControlB
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007