keep focus on textbox

[HarryKlein]

Hi
I want the user to enter numeric value or nothing into a textbox.
If it is not the case,then I want to keep the focus on the textbox.
The code I wrote works fine, but the focus moves to other element. What do I do incorrectly?
I tried the afterUpdate event, bit it didn't help.
Thank you

Please Login or Register  to view this content.

[rorya]

Instead of Me.txtEUR.SetFocus, just use:

Please Login or Register  to view this content.

[HarryKlein]

Thanks
And before or the afterevent is the right approach?

[rorya]

BeforeUpdate is more appropriate, and AfterUpdate doesn't have a Cancel parameter.

[HarryKlein]

Many thanks for the help