I have a field that when another field is updated, I want it to show the difference. I have this below:

Me.Text127 = DSum("[jrnl_entry_amt]", "claims") - DSum("[total_wire]", "total_claim")

So when someone updates the value on the form, I want the Text127 field to update to show if it is matching or not.

I tried putting it on the main form in many different places, on dirty, on change, on enter.

Also tried putting it for the field that the user changes also but I can't get the Text127 field to update when I change the jrnl_entry_amt field.

Any ideas?


Kevin Kristensen