Please help: Struggling as a beginner in South Africa
Having problems with updating Access database.
I have data in the field(s) and I am trying to update the field with Null, In other words replace the current data witg nothing.
It work if fields are text but not if a number.

Data type in database is Number, Long Integer, not required


Code on form:

Private Sub cmdUpdate_Click()

Data3.UpdateRecord
Data3.Recordset.bookMark = Data3.Recordset.LastModified

updateerror:
MsgBox Err.Description

End Sub

This returns error massage: Data type conversion error