Hi Marcia,
Which came first, the chicken or the egg? <g>
If the system assigns employee numbers (as I think it should), they won't know the new employee number. So I'm not really sure what information Alan is saying the user has already put in that field (unless they already typed something before realizing they need to add a new employee).
>Hi Alan.
>
>
I have a situation where the user is entering employee numbers in a text box. If the data is valid, cursor advances to next object. If data is invalid, focus stays in the original text box. I have a button on the screen to allow the user to add new employees to the table. If they have entered and invalid employee number in the field, and then click the add button, the data is still in error and the valid event is processed on the text box. They have to clear the data before clicking the add button.>
>I would handle this situation a little differently than you are. I would call a method from the Valid() of the text box that would pop up a message box saying something like "This employee number is not currently in the datanase. Do you want to add this employee now?" Then, if the user answers yes, you can pop up the form that allows the user to add the new employee.
>
>You can still have the button that allows the user to add the new employee. You just call the same method from both the employee number text box and the click event of the command button.
Steve Gibson