doran_doran
Registered User.
- Local time
- Today, 14:30
- Joined
- Aug 15, 2002
- Messages
- 349
Hi,
I am keep on getting Write Conflict whenever I check a check box called chkHCE. There are over 3000 records and it's happening for every records. I would understand if it's happening once in a while but it's happening for every records.
Please suggest. I attached the error print shot. The data souce is a qry but updatable query. The query has two tables tie together. I never had any problems. Can anyone share their idea Please ???
Thanks
Code behind the chkHCE
Private Sub chkHCE_Click()
If Me.chkHCE.Value = True Then
Me.HCEInitialPrepared.Enabled = True
Me.HCECompletionDate.Enabled = True
Me.HCEType.Enabled = True
Else
Me.HCEInitialPrepared.Enabled = False
Me.HCECompletionDate.Enabled = False
Me.HCEType.Enabled = False
End If
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Me.CWSubform.Requery
Me.PlanWeight.Value = Me.PlanWeightCalc.Value
End Sub
I am keep on getting Write Conflict whenever I check a check box called chkHCE. There are over 3000 records and it's happening for every records. I would understand if it's happening once in a while but it's happening for every records.
Please suggest. I attached the error print shot. The data souce is a qry but updatable query. The query has two tables tie together. I never had any problems. Can anyone share their idea Please ???
Thanks
Code behind the chkHCE
Private Sub chkHCE_Click()
If Me.chkHCE.Value = True Then
Me.HCEInitialPrepared.Enabled = True
Me.HCECompletionDate.Enabled = True
Me.HCEType.Enabled = True
Else
Me.HCEInitialPrepared.Enabled = False
Me.HCECompletionDate.Enabled = False
Me.HCEType.Enabled = False
End If
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Me.CWSubform.Requery
Me.PlanWeight.Value = Me.PlanWeightCalc.Value
End Sub