That may be best practice but unfortunately I need to do the calculations and have them stored in the table. I have been playing with the SaveRecord button click event, but my data just is not saving as I expected. This is what I have thus far and maybe someone can help me iron out the wrinkles
Code:
Private Sub savebutton_click()
DoCmd.RunCommand acCmdSave
DoCmd.RunSQL "UPdate [SalesTable] Set [SaleTotal] = NZ([saleAmt],0)+NZ([SaleTax],0) Where [saleid] = CSTR(" & Me.[Saleid] & ") "
But when I view the actual calculation it always shows either a 0 or -1 which is not accurate.