Hello,
I have a form on which I have added an unbound textbox (txtResult) which I would like to return a given value depending if data is entered or not in another textbox (txt3).
Currently, txtResult shows a value between txt1 and txt2 (which is located in a subform.
txtResult has the following control source code:
Code:Copy to clipboard
[txtAmount1]-Forms!Form1!Subpartial!txtAmount2
Is it possible that txtResult shows by default, the formula which I have indicated in the Control Source and the value 0 (zero), if txt3 has data?
Thank you
I have a form on which I have added an unbound textbox (txtResult) which I would like to return a given value depending if data is entered or not in another textbox (txt3).
Currently, txtResult shows a value between txt1 and txt2 (which is located in a subform.
txtResult has the following control source code:
Code:Copy to clipboard
[txtAmount1]-Forms!Form1!Subpartial!txtAmount2
Is it possible that txtResult shows by default, the formula which I have indicated in the Control Source and the value 0 (zero), if txt3 has data?
Thank you