Re: On Click event procedure skipping the On CLick code
The only time I've ever seen something like that was when somehow the code in question wasn't properly linked to the button. It happened when the button got renamed and then was renamed a second time back to the original name, but by that point the damage was done. Except... the solution was simply to open the form in design view, select the button, bring up the property sheet to the event page, and click the OnClick event to verify that it was set for "[Event Procedure]" - and then double click that property so as to bring up the code associated with the event. That sequence relinked the OnClick event to the code.
That's the ONLY time I've ever seen that. But if the code in question seems to be working, I wonder if you have been looking at an entry point name tainted by a spelling error or something like that. In other words, looking at old code when code exists for a different name.
Yes, it is a long shot. But it might explain the facts.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.