Ofcourse this is possible, but I would use a lot less code.
Start with adding a [Save] and [Cancel] button to the form.
Next test when the [Save] is pressed or all fields are filled correctly and or the user has changed something has been made like:
-
IF Me.Dirty then
-
' the update code
-
END IF
-
Now issue an Append query with the unique record identifyer like:
currentdb.execute "INSERT INTO tblTraceLog (...) values (.....)"
and close the form to save the data.
Getting the idea ?
Nic;o)