I am trying to do a data validation test before a field is updated. I have added a beforeUpdate procedure which does the test that I want. Problem is, I can't keep the focus on the control in question. I want to keep them there until they either enter something valid or clear the field.
I tried doing a setfocus in the before update and got the warning that I have to save the field before I can set focus to it.
How should I be doing my validation to achieve the desired result?