Checkbox Click w/o AfterUpdate Firing?????

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

I have a subform that is showing in continuous form mode. The first field
in the form (i.e., the first field showing for each record) is a checkbox.
If the user clicks the checkbox, a significant amount of code gets executed
in the After Update event for the checkbox.

I've found that if users click fast enough, they can wind up with two or
three checkboxes clicked but the checkbox After Update event only fires for
the first record. This is causing a significant problem in my application.

I've tried disabling the checkbox while the code is executing, and I've
tried locking the checkbox while the code is executing, but that doesn't
help (it's almost as if Access is remembering that I clicked on the checkbox
and it's waiting for the enable/unlock to change the state of the checkbox).

I get this under both Access 2000 (WinXP) and under Access 2003 (WinXP).

Is this a known behavior of Access and is there some way of protecting
against it? The users very much want the functionality to work the way it
works now (code executes on the checkbox After Update instead of the form
After Update), so I would rather not change the functionality if I can avoid
it.
 
Back
Top