ActiveX "Spin Button" control may not work due to any missing reference. You can check this by going to the code section of it and go to Tools-->References.. In the opened popup, it will indicate as MISSING if there is no reference for it.
I have 5 references selected, none are missing:
Visual Basic for Applications
Microsoft Access 12.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft Visual Basic for Applications Extensibility 5.3
Microsoft Forms 2.0 Object Library
The Microsoft Forms 2.0 Object Library has the "Spin Button" control.
I finally resorted to using "premium" microsoft support. Microsoft confirmed the spin button updated event is a known issue in Microsoft Access 2007 but not Microsoft Access 2010. A suggested workaround is to use the change event, which works in both Microsoft Access 2003 and Microsoft Access 2007, but has a drawback: the change event is not a listed property. I found the same problem with the Microsoft Forms tab strip control. Same (unattractive) workaround applies.
I'm pressing microsoft to post something on microsoft.com. While it may be a known issue to the premium support team, it's clearly not a known issue to those of us who tried to resolve the problem. If microsoft actually does end up posting something (I'm told this can take weeks), I'll post back here.
I tend to follow that approach too, HiTechCoach. As you can see, I have only the bare-bones references in my application.
With one glaring exception: Microsoft Forms 2.0. And even of those, I only use tabstrip and spinbutton.
Silly me for making an exception though eh? I figured since they were bonafide Microsoft controls, not 3rd party or anything, and always pre-installed (at least I don't remember seeking them out via downloads), I'd be safe.