Ms access form calculation updating table
Check the format of all the fields, are they numerically formatted versus textual, (the default is text). Who takes 7 seconds to develop,7 mins to document,7 hours to test,7 months to fix will always blame the clock. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Visit Stack Exchange I want to know if it's possible to create a form that has read/write access to a very specific (filtered) record set of a table. Create a query which filters the records of a table. Create a form with this query as its Record Source. When I was heavily into Access development I hit this problem a few times.When I click back to the row I changed, the numbers go back to what they are supposed to reflect.I changed the code to the following: But the same strange thing happens......I would like the calculated field to keep a running total and display the current total no matter what field I begin entering data. Thanks, Brian Ok, place your formula in the controlsource property of your Total field. (not bad at adapting it though)Thanks, Brian Brian All you have to do is go to the property for each field and look for After Update Select Event Procedure.
It looks like the numbers change to the old settings.
As @Saulysw mentioned, the select query should allow you to update.
Can you post the SQL of the query you are using as a source?
The sum is not displayed until data is entered in one particular field.
I believe this is the last field I added to the DB. I'll look into the code option, but I am a rookie when it comes to writing code.
From the wizard, add all the fields into the box on the right, then select the defaults until prompted with the name of the form on the last page.