I don't know which version of Access you are using (97 for me), but I use this. I am assuming you are using a bound form. This will add the record and make it current.

'do your checking
' open a recordset based on your table or query

With rst
.AddNew
' write your data
.Update
Move 0, .LastModified
Me.Bookmark=.Bookmark
End With