>I really want to validate on the text box. Can't enter or tab out unless the value is blank. But if the code is really valid, but just not in the table, I ant them to be able to click and add button to open the add screen. When the add is complete and that screen is closed, then be back in the text box. Entry should now be valid at this point provided they enterred the new employee correctly. I want it to go ahead and process the valid event again when they exit the text box.
This produces not only the problem you mentioned, but also another one: The user might never enter the textbox, and the valid event will never fire.
Validating when saving the record solves both problems. Just let the user input any garbage he likes, and when he saves, present him with a list of rules violated.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)