Mouse Wheel

[NewfieSarah]

hey all I am having a problem, and most people dont seem to know what to say and not to give me any ideas. So here we go. I have a form which you can scroll through the reocrds, with the mouse wheel, or through the navagation command buttons with I have created. However when I use my mouse wheel the record changes but it doesnt change my activeX Control. When I use my command buttons it changes. However I would like to have both the options so anyone have any ideas on how to get the activeX Control to change with the rest of my record?? Thanks

 

[jsteph]

...and most people dont seem to know what to say and not to give me any ideas

That may be because you haven't explained yourself. What "ActiveX Control" are you talking about?
--Jim

 

[psemianonymous]

Is there some code you made running in your "change records" command button? If the answer is "yes", then take that code out of the button_click event and put it in the Form_Current() event. I think that is what you need.

 

[NewfieSarah]

I Didnt really think that it mattered what kind of activeX control, since the properties should be the same, but it is a digitial signature active x control.
I dont have a change record button. I have first, next, previous, last, add, edit, undo, save, delete, close, report, capture, and verify commandy buttons located on my form. If you mean that I should add my code for the next button in my form_Current() wouldnt that be weird, since the active x control would need to be updated when scrolling forward and backward. Since a person can navagate forward or backward? Thanks

 

[Ed2020]

Why not just disable the mouse wheel?

Ed Metcalfe.

Please do not feed the trolls.....

 

[NewfieSarah]

My boss doesn't want it disabled it is a nice feature, to have for "lazy people" you know! Just what people get use to I guess! There is always a way to fix a problem you just have to look hard enough to find the answer!

 

[jsteph]

NewfieSarah,
If the ActiveX is bound, then it should change with the current record. If it is bound and is not changing, then try what pseale said, and for kicks put a line like:
Me!ActiveXName.requery
in the Current event of the form.
--Jim

 

[psemianonymous]

Basically what I was trying to say is: I don't know how your system is set up, but if you need to be doing any 'initializing' whenever the record switches, put that code in the Current() event. The Current() event is guaranteed to run on record switch, no matter if they use the mousewheel or use your navigation buttons or press ENTER through the record to loop to the next one...

 

[NewfieSarah]

No my active x is not bond but the textbox populating it is. And it is not changing. I did trywhat pseale said and It didnt work. So I want to got to the rext record in the current evevnt of what? Is that what you are saying??? Thanks

 

[NewfieSarah]

thanks a lot guys, i finally got it to work, the current event works!