saving from a Form into a table

[JiTS]

Hi
My problem is:
I have a Form with different text boxes, those are related to fields in a table.

One of those textboxes is the sum of the other two boxes.
The result is saved into the Form, but NOT in the Table!!!

What should I do? Pls help

 

[dcx693]

What should I do?

You shouldn't store calculated values in your table - unless you have a darn good reason to. You can usually calculate these values when you need to, so why store them? If you insist, you only need to create a field in your table to hold the calculation, set the controlsource of the calculation field on the form equal to the new field name in the table, then use some code (probably in the current event) to set the value of your calculated field.

 

[JiTS]

Thank you for your answer

Still I don't understand your explaination very well, because I use a Dutch version of Access..

Could u pls publish an example?

Greetz,
JiTS