Hello. Is there a way to keep a field from being populated, via a form, with a number that is outside of a range? The number being entered into the field needs to check the value of two different fields, the numbers entered into these two "range" fields determine the range. The field to be populated is compared to the first "range" fields to make sure it's equal to or higher. Then to the other "range" field, to make sure the number being entered is equal to or lower. If the number being entered is within the range, it's accepted. If not, there's a window that pops up.
Or would a query have to be run to do this?
Thanks in advance.