The TaskID field in MainForm in the attached database includes both a validation rule and a NotInList event. How do I get the NotInList event not to fire if the validation rule is disobeyed?
At present, if I enter invalid text into the field, I get the validation message then the NotInList message then the standard 'The text you entered isn't an item in the list' message. This would be extremely annoying for the user. What I want instead is for the second and third messages to be cancelled or bypassed if the validation rule is disobeyed, so the user is given a chance to correct the invalid text.