Unanswered: Error on calculated field on a form
I'm building a straightforward form were the inputter would enter the number of items requested and the number of items then used.
I'm then adding a calculated field on the form to give me the total remaining - IE: Requested - Used = Total Left.
This works fine if the number used is less than the requested (say 50-45), but when the values are the same (making the total zero), I get this error when I try to move to the next record:
"One of more values are prohibited by the valadation rule. '[Number_Requested]-[Number_Used]' set for 'Order_History'.
Enter a value that the expression for the field can accept."
Order_History is the name of the table.
Thanks in advance for any help!
The Safety Dance!
"There are two kinds of people: sheep and sharks. Whoever is a sheep is fired!"