adding values in textboxes MS Access
Posted on 2012-09-10
I have an access form with 4 textboxes on it formatted as currency.
The user will enter dollar values in the first 3 textboxes and I want the total displayed in textboxTOTAL. If the user makes a change to any of the values, I want the total to be recalculated. And how do I avoid confusing things such as when a total already exists in textboxTOTAL and the user makes a change to any of the texboxes that is not immediately reflected in textboxTOTAL.
For example, let's say these are currently the textbox values:
Now let's say a user deletes the data in textbox1. How do I avoid things like the following:
textboxTOTAL $10000 <----value is still showing $10K even
So I'm also looking for the proper way to handle recalculations. Thank you.