Inserting value of an unbound Textbox

[Addy]

hi,

i got a form in which a integer value (Number) is being calculated based on
the unput the user is giving in the different fields, now i want to insert
this data in a field in my table, when the input is saved

any bright ideas?

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[ryguy7272]

DON'T save it to the table. Queries are great for calculations, and you can
do calculation in forms and in reports too. However, everything is done on
the fly, as you go. I used to think it was a good idea to save the results
of calculations back to a table. After I tried to do what you are trying to
trying to do, and even put up a few posts here, I realized there really is no
reason to do such a thing.

Good luck.