Slider Control MSaccess on update

The on update does not seem to work on the activex slider control, any clues ?
Who is Participating?
peter57rConnect With a Mentor Commented:
Correct. It doesn't.
Use the Change event instead.
The Change event doesn't show on the properties dialog but you can select it in the code module.
Jeffrey CoachmanMIS LiasonCommented:
peter57r, (thenelson)

<The Change event doesn't show on the properties dialog but you can select it in the code module.>

Any idea why this happens?

I notice that the same thing happens for certain events with the calendar control as well.
(they are available in the VBE, but not in the property box)

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Leigh PurvisDatabase DeveloperCommented:
The events displayed on the property sheet are those of the container control.
The actual activeX control object sits inside this wherein its properties, methods and events are accessible.
Hence why the proper syntax for assignment of such control use is

Set objCtl = Me.ControName.Object

As for the event, well Change is alright, but I'd say the point of a control such as the slider is to make use of its dynamic movement (if you're going to include the potential burden of ActiveX controls, you might as well let them sing ;-)
Consequently, I'd say the Scroll event is more applicable than Change (which won't be raised as continuously, i.e. smoothly).
For example of the effect I mean - have a look at:
Jeffrey CoachmanMIS LiasonCommented:
I don't think the default behaviour of the slider justifies the use of the term 'scroll'!
(Yes I know you can change it)(:-)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.