>Chad:
>
>A little later, but maybe I can still help you....
>First, Install VB SP4, that fix many DataGrid's bugs.
>I had your problem too. How to Cancel Add Record in DataGrid?. Well, this is my solution:
>
>Private Sub dbg_LostFocus()
> If dbg.AddNewMode = dbgAddNewPending Then
> dbg.DataChanged = False
> dbg.ReBind
> End If
>End Sub
>
>Like dbg.DataChanged = False set dbg.AddNewMode to dbgNoAddNew, you could validate your required fields on LostFocus. If data doesn´t agree with your specifications then set dbg.DataChanged = False and AddNew operation is canceled.
>When click on another record...?. Try BeforeUpdate, AfterUpdate and RowColChange. I don't have tried that. Maybe it works.
>
>German
Thanks, But I have it all working now.