nope im not manually assigning value to autonumber field. As you can see in my post#5, I just use
Code:
daGrade.Update(dsGrade.Tables("tblEnrol"))            
dsGrade.AcceptChanges()