Spin Down Event skipping one record

[serose14]

I am creating a VBA userform and using a table as a database. I have a spin button created with both SpinDown and SpinUp Subs that allow me to scroll through the database records. When the form initializes, it shows the most recently added transaction on file. When pressing the SpinDown button, one record is skipped, i.e. if the last record is 100 and SpinDown is pressed 98 shows, not 99. Continuing to SpinUp or SpinDown and 99 will show, just not on the first SpinDown event. Other than this, the spin button works fine. Same exact scenario when a new record is added.

Does anyone have any general ideas of what might be wrong? I know I can post the code and someone can help, but I'm trying to figure this out on my own, maybe with a few clues.

If need be I will post my code.

Thank you in advance for your help.

[AlphaFrog]

Can you determine if the Sub is triggered twice or is it moving two records for one execution?

Post the code please.

[AlphaFrog]

Can you determine if the Sub is triggered twice or is it moving two records for one execution?

Are there any other event procedures for the SpinButton other than the SpinUp and SpinDown procedures?

Post the code please.

[serose14]

Code attached. Thanks.

Please Login or Register  to view this content.

[AlphaFrog]

Check that the SmallChange property for SpinButton1 is set to 1 and not 2.

[serose14]

Yes it is.

[AlphaFrog]

Can you attach your workbook file?

[serose14]

Workbook attached.

[AlphaFrog]

Your workbook functions as expected for me. The spinbutton shifts one record at a time.

I'm wondering if your mouse is somehow double clicking or sending clicks too fast.

As a test: with the spinbutton control active, use the keyboard up\down arrows to change records. Does that make a difference?

Another test: increase the spinbutton .Delay property to say 200 or more. Does that make a difference?

[serose14]

I pushed the delay up to 5,000. I also tried using the keyboard vs. the mouse. Still opens to record 7, and when spin down is pressed or selected jumps to record 5. If spin up is selected next, it does go to record 6. Weird. I'm going to try it on another computer. Thanks.