Records in form been save but with different User

[Jamibollah_abbas95]

Hi there. I have a call table that will keep data for all the contact that all telemarketers need to call each day. Each data will be assign to their name. Some contact will be assign to 2 telemarketers. We will use "Edit calls details" Form to edit the contact after we made a call. Example i have 2 different Telemarketer and they have to the same person in one day and although the (Telemarketer 1) Call the contact first but the data is updated under (Telemarketer 2) records. Can you guys help me to solve this?


This is my VBA code?

Option Compare Database
Private msaved As Boolean




Private Sub Campaign_Name_AfterUpdate()
Me.Requery
End Sub


Private Sub Command203_Click()
    Dim App As Outlook.Application
Dim oMail As MailItem
Set App = CreateObject("Outlook.application")




Set oMail = App.CreateItem(olMailItem)
oMail.Body = "Dear" & Me![First_Name] & "," & vbCrLf & vbCrLf & "It has been six months or longer since I last contacted you. Have there been any big gains with regard to impact?"
oMail.Subject = Me![Campaign_Name] & "- check up"
oMail.To = Me!Email
oMail.Display
Set oMail = Nothing
Set App = Nothing
End Sub


Private Sub Form_BeforeUpdate(Cancel As Integer)
If msaved = False Then
Cancel = True
Me.Undo
Cancel = False
End If
End Sub


Private Sub Form_Current()
msaved = False
End Sub


Private Sub Form_Load()


End Sub


Private Sub save_record_Click()
msaved = True
MsgBox "Records Saved"
End Sub


Private Sub SDRname_AfterUpdate()
Me.Requery
End Sub


Private Sub ID_AfterUpdate()
Me.Requery
End Sub

[Welshgasman]

I am going blind in my old age.?
I cannot see anything in that code that shows a caller field being updated.?

If you have a field in a table for that form that holds the CallerID then the last person to call is always going to update that field last.?

You should likely have a separate Call table that holds CalledID and ClientID with Date and Time etc. if you want to see the 'history' of the calls.?

[Missinglinq]

The 'gasman is right...and the Call table needs to be displayed as a Subform to your Main Form...with the Subform being sorted on the Call_Date and Call_Time fields.

Linq ;0)>