Calculated Form Controls with Access 2007

[bUttA]

Hi guys,
I'm new to using Access but have I some familiarity with databases in general. I have a quick question for the gurus here.

I'm trying to work with a Form in Access that has a Calculated control. Each one of the Controls on the Form is bound to my table to its respective field. My problem is that once a record is saved, the value in the Calculated control doesn't appear in the table.

By this I mean... It seems that the calculation is being performed on the form but not saved to the table. Why is this happening? Is there a property I need set to allow these Controls that are Calculated to store the values?

I'm sure I'm missing something really simple.

I didn't think you'd need the tables and properties that I have setup but if you do, I'll gladly post the info.

Thanks for your help!

[MSeda]

if you've entered the formula in the control source for the calculated control then the control is no longer bound to a specific field.
in order to display the calculated value and have it saved in the underlying table delete the formula from the control source and set that to the field where you'd like the data saved. then in the properties of the controls that this one's value is based on create an event procedure in the after update event.
your event code is just the formula that you removed from the control source.
sub text1_afterupdate()
me.calccontrol = me.text1 *me.text2 (for example)
end sub

[bUttA]

Hi MSeda,
Thanks very much for the solution. With your information I was able to get data into the table as I needed!

Best Regards

[MSeda]

Glad to help.

[NeoPa]

Nice work again M :)
And well explained.