Hello All,
I have seen many threads on this mouse wheel issue, but all I am looking for is an appropriate code to deal with my related problem.
My form opens to a new auto-number record of, say, 100. If you scroll the mouse wheel forward the record remains at 100. If you scroll backwards, the record changes to "auto-number". Forward 100, back "auto-number" and so on.
In the "On Mouse Wheel" event I have entered a simple piece of coding along the lines of "DoCmd.GoToRecord , , acLast". When I scroll the mouse wheel backwards, the field briefly flickers to 100 (as if it wants to go to the last record), but then remains at "auto-number". Scroll the mouse forward and the record changes to 100.
I have tried many codes to say something like "if this record is equal to auto-number, go to last record", but without any luck as yet. The problem for me is when the mouse wheel is scrolled backwards.
Thanks in advance.
L.
I have seen many threads on this mouse wheel issue, but all I am looking for is an appropriate code to deal with my related problem.
My form opens to a new auto-number record of, say, 100. If you scroll the mouse wheel forward the record remains at 100. If you scroll backwards, the record changes to "auto-number". Forward 100, back "auto-number" and so on.
In the "On Mouse Wheel" event I have entered a simple piece of coding along the lines of "DoCmd.GoToRecord , , acLast". When I scroll the mouse wheel backwards, the field briefly flickers to 100 (as if it wants to go to the last record), but then remains at "auto-number". Scroll the mouse forward and the record changes to 100.
I have tried many codes to say something like "if this record is equal to auto-number, go to last record", but without any luck as yet. The problem for me is when the mouse wheel is scrolled backwards.
Thanks in advance.
L.
