Hi - I have a form where errors are tracked - Each error represents a particular error point - I have created seperate text boxes that I will hide next to each text box. When the member clicks the particular text box, the after update event of the check box populates the corresponding text box with the error points - The points vary from 25 to 100 points with no one record exceeding 100 points.
My problem is the text box I am using to total the error points. I am simply using the nz function and adding them such as... =NZ([textbox1])+NZ([TextBox2])....
I tested this with only 3 text boxes - The problem is it assigns the correct value in the hidden text box but sums the first text box as 2500 (instead of 25) the second text box as 250 (instead of 25) and so on - I am guessing as I add text boxes to the text box that adds the fields the problem will continue.
What am I missing? Thanks so much for the assistance!!!!
My problem is the text box I am using to total the error points. I am simply using the nz function and adding them such as... =NZ([textbox1])+NZ([TextBox2])....
I tested this with only 3 text boxes - The problem is it assigns the correct value in the hidden text box but sums the first text box as 2500 (instead of 25) the second text box as 250 (instead of 25) and so on - I am guessing as I add text boxes to the text box that adds the fields the problem will continue.
What am I missing? Thanks so much for the assistance!!!!
