Update query field from form using VBA - Write Error Conflict

[jamphan]

I am attempting to update 3 date fields from an unbound form field using VBA. The form is based on a query. Below is the code I am using but when I change the date I get a Write Conflict Error message. The query is based on 1 table. Any help is greatly appreciated.




Private Sub Calendar3_Click()
Select Case Me.DescLabel.Caption
Case "Date Notified"

Me.DateNotifiedNew.Value = Format(Me.Calendar3.Value, "General Number")
DoCmd.Close acForm, "frmcalendar", acSaveYes
DoCmd.Requery

Case "Date Title Requested"

Me.DateTitleReqstdNew.Value = Format(Me.Calendar3.Value, "General Number")
DoCmd.Close acForm, "frmcalendar", acSaveYes
DoCmd.Requery

Case "Gap Claim Notification"

Me.DateGapInitiated.Value = Format(Me.Calendar3.Value, "General Number")
DoCmd.Close acForm, "frmcalendar", acSaveYes
DoCmd.Requery


End Select
End Sub

[help_me_with_access]

write conflict? well maybe the query is a non-updateable type?

what's the query's SQL? do multiple people use these forms? write conflicts also occur during locked form sessions, I THINK. either that or it says something like "permission denied" to the user in violation of the request.

[jamphan]

The weird thing is the code and form worked perfectly for years. Someone added a couple of records to a table that feeds a drop down menu on the form and now the date fields no longer work.

[help_me_with_access]

hmmmm...well to be honest with you, there are literally millions of people out there, even professional developers, that end up doing things in access that would otherwise be considered OK. Access is difficult. It's not a trustworthy program, generally speaking. It's hard to say if the other person violated one of Access's "unknown" rules or if you've run into the common problem of corruption.

not sure what to tell you. Other than to backup your access files at least once a day and in more than one place (more than one computer) simply because of the reason stated above.