Recordset

[Kock1]

I have created a form which is connected to a database via odbc. If i make a new post and type in a field and the erases it i get an error message which says that the field in question cannot be of zero length, but if i write nothing in the field it works fine.
The save button code looks like this:

On Error GoTo UpdateErr

adoPrimaryRS.UpdateBatch adAffectAll

If mbAddNewFlag Then
adoPrimaryRS.MoveLast 'move to the new record
End If

mbEditFlag = False
mbAddNewFlag = False
SetButtons True
mbDataChanged = False

Exit Sub
UpdateErr:
MsgBox Err.Description