January 20th, 2013, 10:16 AM
Automation Updating a field in a table
I have a form which enters data into a table. Field total amount (FieldF) is an equation of ((FieldE*FieldD) * (FieldA+FieldB+FieldC)). When I enter the equation into the text box the correct amount is shown, but it is not linked to the field in the Table where FieldF, the control source has been replaced by the equation. I have tried to use a query using FieldF: ((FieldE*FieldD) * (FieldA+FieldB+FieldC)) selecting FieldA's Table in the table column. This didn't work either and returned a automation error? any suggestions.
January 20th, 2013, 04:08 PM
It is not a good practice to put calculated fields into tables. If data changes then you have to update all the calculations or you could end up with misleading or bad information. Calculations should remain in forms for viewing, in queries and reports for analysis and reporting. All calculations can be done on the fly in queries and forms as needed.
Office 2010, 2007, 2002
If I helped you, then click "give rep" button in the lower left corner.
January 20th, 2013, 09:14 PM
Thanks for the reply. I have to find another way around