one of my users wants me to create an unbound field that is equal to the invoice total to use it as a check figure for when he makes adjustments to the invoice he wants to see that he hasnt added or removed to much.
I have tried this in the on open
Dim OriginalTotal As Currency
OrginalTotal = Me.TotalForInvoice
Me.OriginalTotal = Me.TotalForInvoice
but when i do the field is blank
I just need a new unbound field that will show the same value as TotalForInvoice when the form opens so he can compare the changes he made and make sure the totals are still the same. The TotalForInvoice is also an unbound field, if that matters.
Thanks