I have 2 textboxes on a form, when I enter a number to textbox1, the textbox2 should automatically add 5 to the value entered on textbox1 and displays it. (So I have, =[textbox1]+5 on textbox2's control source).
Now my question is how can I make textbox2 to not go over 100? For example, if I enter 98 on textbox1 of course textbox2 will give me 103.
How do I make textbox2 to stay 100 if the value goes over 100?
Now my question is how can I make textbox2 to not go over 100? For example, if I enter 98 on textbox1 of course textbox2 will give me 103.
How do I make textbox2 to stay 100 if the value goes over 100?