Passing a calculation to a field

[dome]

Greetings,

How can I pass and save a calculation that is in the Control Source property into a field on the table

(eg. I took two values from existing fields and did a calculation on them. The sum is
displayed on the screen in another text box.
How do I save this to a field?)

Thanks

Dome

 

[D B Lawson]

Access isn't really designed to save dynamic calculations. What you have done up to now is fine. There shouldn't be any real reason to save the calculation in the base table because you can create it on the form for view from the two fields that you do save.