Ed,
Try setting the ActiveColumn property of the grid to the column contaning the item number in the ADD button before you do the APPEND or INSERT.
That worked for me in a slightly similar situation.
>I have created a form with add cmdbutton and a grid. Once I pressed the add button the focus will set to one of the columns in the grid an I will input an itemno and will then replace other data in the other columns when itemno is found. the focus will then go to the qty column for input of quantity. Once I press enter to confirm the focus will go back to add button. This is where the problem start, when I pressed the add button again it will again evaluate the valid and lostfocus of th qty column and will go setfocus back to add button since the qty.lostfocus has setfocus() to add button.
***************************
Bruce Gilmour
"Two things are infinite, the Universe and human stupidity. And I am not sure about the Universe."
- Albert Einstein