0

I want to obtain Numbers from different forms, add them up and display the output in a different form.

For example, There are two forms: Form 1 and Form 2. The information I need is located in Form 1. So I get the numbers from Form 1, add them up and display the result in Form 2.

I am not sure how to proceed here. Please advice.

Ish
  • 671
  • 5
  • 21
  • 36

1 Answers1

0

Select the text box where you want to output the answer, go to properties > Go to data>Constrol source>click on "..." and type the following code:

Forms!Form_3!Text_3.Value=(Val(Forms!Form_1!Text_1.Value)) / (Val(Forms!Form_2!Text_2.Value))

Ish
  • 671
  • 5
  • 21
  • 36
  • No, that will not work the way you have it and it is probably not a good idea. – Fionnuala Jun 06 '12 at 19:22
  • I cannot tell you unless you can say what is the real world problem that you wish to solve. The above has quotes, which will stop it working, and unnecessary functions and properties. – Fionnuala Jun 06 '12 at 19:47
  • I have editted the above comment. That is how I have it in my text box property. – Ish Jun 06 '12 at 19:49
  • I want to get a number from form_1 and multiply it with a number in Form_2. Next, I want the output to be displayed in Form_3, text_3. – Ish Jun 06 '12 at 19:50
  • 1
    Why? Why would you want to confuse a user with three forms? – Fionnuala Jun 06 '12 at 19:59
  • That is what I want/ What the user want – Ish Jun 06 '12 at 20:11