Linking a form total's field to the table
Posted on 2012-08-21
I created a form to track the cost for each piece of stolen/lost equipment. I then created a totals text box within the form to produce a total value for all equipment. I am able to get the total field to populate in the form by inputting =[field1] + [Field2] in the data control source; however, the problem i can't figured out now is how to link this field to the table. This would typically occur though the same control source, but now that it is filled with the adding of fields i am not sure how to get this total to populate in the table.
Let me know if you have any questions.