Access TextBox Sum Dynamically

[RAJESHKUMAR R]

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

[xps35]

Add Nz(Amount1, 0) + Nz(Amount2, 0) + Nz(Amount3, 0) + Nz(Amount4, 0) + Nz(Amount5, 0)

[RAJESHKUMAR R]

Dear xps35,

Thank you so much for your quick reply; it is working amazingly!

Thanks & Regards,
Rajeshkumar R