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?
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