With the exception of a few situations, calculated values should never be stored in a table, but rather re-calculated as needed. The fact that you want these values to be re-calculated every time the form opens indicated that this is npt one of those rare situations!
It would help us to help you if we had a more detailed explanation of what you're trying to do.
As a simple example, let's day TextboxC = TextboxA + TextboxB
One approach would be to have the Control Source set to the formula. In Design View for your form, select TextboxC then goto Properties - Date and in the Control Source Property enter
= [TextboxA] + [TextboxB]
You would have to do the same thing in order to include TextC in a report, using the same thing as the Control Source of an unbound textbox on the report.
Another approach, probably the better choice, would be to create a query on your table. In truth, because of issues just like this, most forms should be based on queries, even when only a single table is involved. Among other things, you can create a calculated field once, and it will be available to you, freom that pont forward, without having to re-calculate it again. Instead, the query automatically re-calculates it, every time the query runs.
In the Design Grid for the query, in a blank filed, you would enter something like:
CalculatedFieldC: [FieldA] + {FieldB]
With your form based on the query, simply assign the Control Source of TextboxC to the query's CalculatedFieldC. In a report, using this same query, you'd do the same thing.
Linq ;0)>
Sorry for the late post! Having connection problems today!
2
