title: update tables and calculated fields without opening form
body: <p>I have an Access 20 database that has data linked to a SharePoint Library List. The Data is collected via an Infopath form. </p>
  
  <p>In the database, the Form used to display data related to each project uses a query to draw from a table of clients and a table that tracks the costs for the project. The for contains a subform which tracks the time spent on a project  calculating time elapsed between the time started and time stopped. Am umbound text box in the footer of the subform calculate the sum of the hours worked and a text box on the main form displays the total hours worked from the subfor.</p>
  
  <p>Data entered via the infopath form does not get calculated in the mainform until the form is opened. As some users do no even go into the database and enter their data via the Infopath form only, the time spent on these one-off projects do not get tracked on the main form either - only the sub-form hours table.</p>
  
  <p>Now here is the question: how can I code the data to calculate without opening each project in the form view?</p>