Thanks for confirming that jmcilhinney

I (as you may know) moved from VB6. In VB6 I never used bound controls to a DB, I always coded the operations myself. That way I could always validate the data entered prior to commiting it.

I concur with the stack results, and that is what I found difficult to work around. As mentioned, others have had a similar issue - no resolution in sight.

I have tried to add a value to the last row when the add button is pressed(similar approach to a default), but the value gets added after the new row once its been added. I used the row count -1, but then it must get recalculated.....