Forum Discussion
Asynchronous Event processing in Access 365 ?
I have a client that recently upgraded from standalone office to Office 365. Today they called with an error that on first glance defied logic. But upon delving deeper it appears that Access is exe...
David_Richardson Can you put a really small db together that demonstrates this problem? I for one am skeptical. Access is of course multi-threaded, but it has only one UI thread.
I will attempt to put together something to demonstrate it, but maybe an explanation. Based on what you have said... The AFTER UPDATE event called a function from a Code Module, while the ON KEY DOWN was executing code behind the form. In that case could it have cause them to execute simultaneously?
What was happening is the ON KEY DOWN checked a condition IF X.ENABLED=True Then Set Focus to field X. The Code called in the AFTER UPDATE event checked various other conditions and set the X.ENABLED = FALSE. So from what we could determine it looked like the ENABLED property evaluated TRUE in the ON KEY DOWN's IF statement, then the value was changed from the Function called by the AFTER UPDATE event before the ON KEY DOWN tried to Set Focus to field X.
What was happening is the ON KEY DOWN checked a condition IF X.ENABLED=True Then Set Focus to field X. The Code called in the AFTER UPDATE event checked various other conditions and set the X.ENABLED = FALSE. So from what we could determine it looked like the ENABLED property evaluated TRUE in the ON KEY DOWN's IF statement, then the value was changed from the Function called by the AFTER UPDATE event before the ON KEY DOWN tried to Set Focus to field X.
