Greetings!!!
I am newbie in Access, so I need a little of your assistance.
I have a form, let's say it is called "MyForm" which includes multiple textboxes that are connected with a table called "MyTable".
Every time that I want to have data from one of my textboxes to a specific field of "MyTable", I add this field to the Control Source in the Data Section of properties of my textbox and I achieve it.
Now, there is a textbox in which I want to have multiple if functions and the final result to be added to a specific field of "MyTable".
Let's say that the if function in my Text83 (textbox) is the following:
IIf([SUM]<=5;"Low";"High") (The SUM textbox, is a textbox which makes calculations all the time, depending on the values that the user adds)
Now I need the result of Text83, either if it is Low or High, to be added to the field "Result" of "MyTable".
I already tried by having as Control Source "Result" of "MyTable" and "default value" the iif function, but I only achieved adding the value that it is initially calculated and not the final value.
Is there anything you can suggest?
Thanks in advance!!!