Dear Friends,
In an Access Form I have 5 textboxes named as Amount 1,2,3,4 & 5 respectively…
Then I have a Textbox named as Total Amount which is Sum of Amount 1 to 5 textboxes…
Concern:
Total Amount Textbox getting summed and shown result only after all 5 textboxes i.e., Amount 1 to 5 are updated…
But my scenario is not every time all Amount 1 to 5 text boxes required to be updated…
It can vary from Min 1 to max all 5 text boxes may get updated…
Support Required:
Total Amount Text Box to show summed result dynamically based each Amount 1 to 5 textbox update….
Note: I would like to accomplish this without any VBA
Thanks & Regards,
Rajeshkumar R