Would it be possible to combine records when a Write Conflict happens?
I was looking at using the Form_error event and doing something like this but I don't know how to get the data to combine.
Private Sub Form_Error(DataErr As Integer, Response As Integer)
If DataErr = 7787 Then
'Put code here to combine data
End If
End Sub
***Update This is what I have so Far. It adds the data but overwrite what was saved by other user. Is there an append function for this?
Dim rst As New ADODB.Recordset
rst.Open "tableName", CurrentProject.Connection, adOpenKeyset, adLockPessimistic
With rst
.Update
!key = "PrimaryKey" 'Primary Key of record that needs to be updated
!fieldname = Me.FieldName
.Update
.Close
End With
Set rst = Nothing
End If