I want to validate my record when I change to a new row on the grid. The control source for the grid is an updateable view, and optimistic row buffering is on. My form also has a button to append a record to the grid view. Iwould like to test the record contents with a valid method before I switch rows or add another record to the grid, but I can't figure out how to do it.

The scrolled event only fires if I move the scrollbar, it wouldn't fire for me when I used up and down arrows to move through the grid. And I can't find any Row Valid, or Row LostFocus events. The active row property might work, but by the time the active row changes, haven't I already updated the rowbuffered view?

If i'm barking up the wrong tree please tell me. I could probably use table buffering, but I want the user to know right away if the record is correct.

help!

TIA
tony