Fix: This Error Occurs When an Event Has Failed to Run Because the Location of the Logic – Access
You may receive an error when you try updating the database in a Microsoft Access file.
This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs.
Follow this support article by Microsoft here.