Question about MouseWheel

[kobekaren]

hi, i have a question about MouseWheel event !

in my access program, there are two checkboxes, for example, a & b, on a form with contain many record.

sample record:
no. a/b
1 a<---cannot be deleted
2 b<---can be deleted
3 b<---can be deleted
4 a<---cannot be deleted

of course, when i open the form, i can see all the records when i sroll the mouse wheel.

then, one the form, there is a delete button.

Logic is like the following-->
if (a=True) then
delete button is disable
else
delete button is enable

but problem raises, if i put the above coding in the MouseWheel event, it cannot run smoothly.
ie when the form first load, for record 1 , because a = true , so delete button is disable.
when i scroll the mouse wheel and go to record 2 , delete button is expected to become enable. but nothing changes. delete button is still disable.

can anyone help me to slove this problem ?!

THX !!

 

[RuralGuy]

Have you tried putting your code in the Current Event of the form instead?

 

[kobekaren]

It works smoothly....thank you so much for helping me to solve this !!

thank you, RuralGuy

 

[RuralGuy]

You are very welcome.