Some Quries

[Arsalan]

1st Query!


I have 3 text box on form named txt1 and txt2. I am using txt1 and txt2 for assigning values and txt3 for result.
I write this formula in txt3: =+[txt1]+[txt2]
this formula give me perfect result when i provide value in both textboxes but when i don't provide value in any one in this text box then txt3 gone blank. I want that if i insert 5 in txt1 and left txt2 blank then txt3 show me 5 as result.

2nd Query!
In this query i want that when i insert some new values in bound control like textbox(bound with datatable) then Sum of this bound textbox which is in form footer will automatically update/Refres.


thanks in advance.

[ssanfu]

1st Query!
I have 3 text box on form named txt1 and txt2. I am using txt1 and txt2 for assigning values and txt3 for result.
I write this formula in txt3: =+[txt1]+[txt2]

This is not a query. It is an expression.
Try this in txt3 :

=NZ(txt1,0)+NZ(txt2,0)

2nd Query!
In this query i want that when i insert some new values in bound control like textbox(bound with datatable) then Sum of this bound textbox which is in form footer will automatically update/Refres.

As a rule, you shouldn't store the results of a calculation. If the value of one of the fields changes, the calculated value would be wrong. You would have to write code to ensure that the result field is updated if any of the values change.

If the record source is a query (not a table) , you can add a column to the to calculate the result.
Example:

SELECT NZ(txt1,0),NZ(txt2,0),NZ(txt1,0)+NZ(txt2,0) AS Result FROM A_Table

Change "A_Table" to your table name. Set the control source for "txt3" to "Result"

[Arsalan]

Thanks for 1st query it's working but what i need in 2nd query is that...
I want that when i enter some number like '5' in (Green Rectangle) txtbox then (Red Rectangle) box will automatically sum.
which formula resolve this issue?
Note: Red and Green Rectangle box is not bound controls its unbound textboxes.