Hello I need help. I have a drop-down field[SUB size] on my form that shows different size bags (Small, Medium, Large). I test these bags to determine the force before they rip. The larger the bag the larger the force before it rips. I have a calculated field [average pull strength] that averages the force.
I want a message box to pop up to prompt the user to retest because the force is too low. For the BeforeUpdate event in the [average pul strength] I put in a macro:
If (([SUB Size]=Small),([average pull strength]<17),([SUB Size]=Medium),([average pull strength]<20),([SUB Size]=Large),([average pull strength]<23))
Then MsgBox
The macro does not work is my if statement correct?
I want a message box to pop up to prompt the user to retest because the force is too low. For the BeforeUpdate event in the [average pul strength] I put in a macro:
If (([SUB Size]=Small),([average pull strength]<17),([SUB Size]=Medium),([average pull strength]<20),([SUB Size]=Large),([average pull strength]<23))
Then MsgBox
The macro does not work is my if statement correct?