Textbox on form not calculating

[achammar]

Hi All!



So I have 3 textboxes on a form. 2 of them have values (they actually get their values from 2 different subforms), and the 3rd text box adds the 2 together. These textboxes do not have a control source in any table or query. They just perform a calculation. I don't need it saved in a table. So when I fill out my subforms, those first 2 textboxes fill, and the 3rd one shows the sum of the 2. My problem is that if I don't fill out both subforms so that both textboxes have a value, the total textbox is blank. I want it to show the total of the other 2 textboxes even if only 1 has a value. I tried setting the default value to the textboxes to 0, but that doesn't work. I don't think a calculated control can have a default value maybe.

Anyone have a solution?


Thank you!!

Albert

[davegri]

Try
=nz(TextBox1,0) + nz(textbox2,0)

[achammar]

That fixed it! Thank you so much davegri!

[davegri]

Glad to help. Good luck with the project!