Why doesn't a calculated value in a form transfer to the table, i.

[Guest]

I wish to input into a table using the forms facility. Three items which
are directly input to the form, automatically transfer to the table, but a
total of them doesn't transfer. It is shown on the form, but not on the
table. Help. Carl Baker.

 

[Steve Schapel]

Carl,

If a control on a form is bound to a table field, then the data entered
or edited via the form will be stored in the table. If a control on a
form does a calculation, then it can not be bound to a table field. It
is, by definition, and unbound control, and its Control Source will be a
calculation expression. I presume this is the case with your "total".
But in any case, the purpose of a table is the storage of information,
not to do calculations. In general, any attempt to put calculated or
derived data into a table is a violation of database design principles.
Calculated data such as totals is done in queries, forms, or reports,
as required, and there is normally no purpose in saving the results of
these calculations.