If Macro for Form Field : Limit (1 Viewer)

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?

Hi. Not sure if the statement is correct but the BeforeUpdate event of calculated controls don't usually fire just because you updated another control used in its calculation. You could test this by simply using a MsgBox without an If statement to see if you get the message at all.

build the macro on BeforeUpdate like this

Arnelgp, this worked great thank you.

TheDBguy, you were right in that it does not work in a calculated field. I had to put it in a OnClick event in a save button. This did the trick.

Thanks y'all

EdwardsC said:

Arnelgp, this worked great thank you.

TheDBguy, you were right in that it does not work in a calculated field. I had to put it in a OnClick event in a save button. This did the trick.

Thanks y'all

Click to expand...

Hi. Congratulations. Glad to hear you got it sorted out. Good luck with your project.