I have a macro in the OnCurrent event of a subform which updates a query when the user switches to a different record. The problem is that it slows everything down because the OnCurrent macro seems to be executing about three times after each record change. I checked all of my related macros to make sure there was nothing that could be causing a loop, and everything should be fine. Is the OnCurrent event continous for some reason? How can I get the macro to execute only once?
Last edited:
