Forum Discussion
Access error screen does not close after Ok button of error message is clicked
Which event triggers this error? It could be that you are in a loop where the error is raised over and over because you need to undo a control that has the invalid attempted value in it, but until you remove that invalid value, the same error is raised again. I'm thinking perhaps a Before Update event would be the most likely.
Hi George
No, this is not a loop event. It occurred when I opened the Access app and was entering the first record of the day while erroneously entered a data of type different from what was set up for that field.
No. It was not Before the Update situation. The office 365 and Windows update were both up-to-date when this happened.
Sorry, perhaps I was not as clear as I hoped. I'm not talking about an update to the software. I'm talking about an Update event in a control on the form. Like this example, where failing to cancel and undo the attempted invalid entry sends the event into a loop as it tries to update, can't because of the response to the question, but still has the wrong value, so it triggers the before update event again.
Private Sub cboTestTimeOfDayID_BeforeUpdate(Cancel As Integer)Dim lngMealItemCount As Long
With Me
If MsgBox(Prompt:="Click ""Yes"" to confirm you want to change this meal.", _
Buttons:=vbYesNo + vbCritical, _
title:="Change a Saved Meal?") = vbNo Then
Cancel = True
.cboTestTimeOfDayID.Undo
End If
End With
Exit Sub
End Sub- Hi George
I am sorry I am not a technical person and as such not in a position to understand what you have meant to say. I wou[d be thankful if you kindly guide me in layman's language as to how to I can resolve this issue, whatever be the reasons. As I have said, I have been using MS Access for decades but have never before come across such a problem. In the alternative, you may advise if you are aware, of how to contact MS Access Support staff for a chat session for resolving this issue. I had tried through the Access Help option but the lady support staff to whom the chat session was entrusted by MS said I had landed in the Download and installation wing of office 365. As advised by her, I have brought the matter here for a plausible solution
