sum of 2 textboxes should be displayed in third textbox

[aparnawangu]

Hi Friends,


I need a help regarding calculating sum of two textboxes and displaying in a third textbox.How to do that?
Pls suggest.


Thanks in advance
Aparna

[CJ_London]

in the controlsource of the third textbox put

=nz([Textbox1],0)+nz([Textbox2],0)

where Textbox1/2 are the names of the boxes you want to add

the nz function is used in case either of those controls are null

[aparnawangu]

Hi,
Thanks much for help,but the formula which you mentioned above is combining the values rather than suming them up.
eg:textbox1:24,textbox2:1 then Textbox3 showing result 241.Its not adding the values.

One more requirement.I have check boxes connected with Textboxes.I want that only those textboxes values should get displayed whose check boxes i will select(Highlighted One).Pls help me with these requirements.

[June7]

Are textboxes 1 and 2 bound to number type fields?

Are the checkboxes bound to a yes/no field?

Why do users need to manage display of textboxes?

[CJ_London]

Thanks much for help,but the formula which you mentioned above is combining the values rather than suming them up.
eg:textbox1:24,textbox2:1 then Textbox3 showing result 241.Its not adding the values.

sounds like the controlsources for your textboxes are text and not numbers