Re: Automatic totals
I agree 100% with Paul. There is no way to audit a table where you can just increment the values. It is far superior to add these two as separate transactions and then sum the transactions.
However, we are looking at this request out of context and for all we know, you are trying to make a calculator. If that is the case, you would have the bound column which shows the existing value and the result after update and an unbound column in which you enter the value you want to "add" to the existing value. Then either in the AfterUpdate event of the unbound control or in the BeforeUpdate event of the form, you would add the two fields and the result gets placed in the bound field
Nz(Me.yourboundcontrol,0) + Nz(Me.yourunboundcontrol, 0)
You need the Nz() function just in case either column is null in order to avoid an arithmetic error.
Bridge Players Still Know All the Tricks