Data from a form to a table

[Goingcrazy]

Ok, I really need some help here. I have a table called tblServiceInfo and a form called frmServiceInfo. On both there is a field called Total Cost. What I have is a calculation on the form that figures out the total cost based on time and parts. what I need to do is get the total cost that appears on the form for that record to get put into the table. I need to know if this is possible and how to do it. Any help would be greatly appreciated!!

 

[pbaldy]

It's possible, though it's not generally a good idea to store calculated values:

http://support.microsoft.com/kb/209172/en-us

 

[Goingcrazy]

ok i think i may have left a key part out. on the service info form there is a subform which is where the time comes from. so the control source of the total cost on the form is =[Text44]+[PartsPurchased]. text 44 is the control that gets the total time from the subform. Please help. Im still not getting anywhere.

 

[pbaldy]

Users have an uncanny ability to find ways to get your saved total amount out of whack with the items that make up the total. I wouldn't store it. If you must, and I'm sure you'll think you must:

Me.BoundControlName = Me.CalculatedControlName