Dear All

I'm using the following code(which is a part of full code) but this is not working.
Here the variable con is equalize with form field "Conb". I'm using this code on after update event of control "CONB". after this code execution the control jumps to next field but I want that if check is wrong then control should stay at CONB field.

Thanks.

Wasim

Are you familiar with the SetFocus property? If the check is wrong then set the focus at ConB.

I believe the code is as simple as:

"ConB.SetFocus"

Thanks,
ScottG

SetFocus will work, but it's not going to consistently work the way you want it to. If the user pressed Tab or Enter to finish the CONB entry, the setfocus will move the cursor back to CONB, but then the tab/enter will be executed, effectively putting your cursor in the next field. The behavior is different, depending on how the user attempted to exit the CONB field.

The consistent way to handle what you're talking about is to move your code from the After_Update event to the Before_Update event. This will prevent the CONB field from losing scope until the problem is resolved.

Take out the UNDO command, as it won't be needed for the Before_Update. The update hasn't happened yet, so there's nothing to undo.

Also note that your command Cancel = True is correct for the Before_Update event (where you're moving your code to). However, it has no effect in the After_Update event where you currently have it, because there's no Cancel parameter in that event.