BeforeUpdate Event or AfterUpdate Event.. BeforeUpdate has a way to keep Focus on the control
Please take the time to read the Forum FAQ
Forum Rules