Hey everyone,
I'm wondering if this is possible.
I have 4 text boxes on an Edit Form:
Qty on Work Order
Total Qty
Qty Passed
Qty Failed
Qty on Work Order is tied to my ERP system
Total Qty is a calculated field summing Qty Passed and Qty Failed
Qty Passed is user input
Qty Failed is user input
I want to do an If statement on the "Submit" button that I have that submits the form.
What I want to do is If Total Qty > Qty on Work Order, do not let the person submit the form and then display an error message.
Can this be done?? If so, what would the syntax look like?
Let me know if other information is needed.\
Thanks!