Before Update Event Not Fired??

I have a form/subform combination. On the subform, I
have some code in the BeforeUpdate event on a specific
field that after a certain point produces a msgbox. When
ever I enter the values in my subform, at a "normal"
speed, the code is fired at the appropriate time. But,
here is the problem, when ever I enter the values in my
subform at a real fast speed, the before update event
code is completely bypassed. The values will go right
past the fire point without ever being fired.

Is there any one who could explain why this occurs??

Michael Watts
Developer
colorado_ski_bum ~NOSPAM~ at hotmail dot com

If the BeforeUpdate event of your text box does not appear to be firing when
you enter data quickly, it sounds like a timing issue.

Can we double-check that the event is not firing?
Place a MsgBox() on the very first line in the procedure?
Does this work?

As an example, updating a calculated control is a low priority task for
Access, so the event would not *appear* to fire if you had something like
this:
If Me.MyControl Me.[SomeCalculatedControl] Then
MsgBox "It's different
End If
because the calculated control has not been updated if you enter quickly.

Also, a control's BeforeUpdate does not fire if you assign a value
programmatically (instead of typing it in.)

If those ideas do not cover your issue, please post back.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Michael Watts" wrote in message
...
I have a form/subform combination. On the subform, I
have some code in the BeforeUpdate event on a specific
field that after a certain point produces a msgbox. When
ever I enter the values in my subform, at a "normal"
speed, the code is fired at the appropriate time. But,
here is the problem, when ever I enter the values in my
subform at a real fast speed, the before update event
code is completely bypassed. The values will go right
past the fire point without ever being fired.

Is there any one who could explain why this occurs??

Michael Watts
Developer
colorado_ski_bum ~NOSPAM~ at hotmail dot com