SetFocus not re-directing cursor to propr textbox

**Damian37** · 06-18-2014, 09:47 AM

I've set a validation within my userform to force the user to enter in a valid employee ID or a general kiosk #. The validation is working, but the setFocus line I have added to place the cursor back in the textbox in the event the value entered was incorrect isn't working. The cursor is moving on to the next textbox making the user have to re-click on the text box in order to correct the invalid entry. Am I placing my setFocus line in the wrong place of the code? FYI - The second setFocus is working correctly. When the user enters 9999 it directs them to the IT Ticket number text box. Prior to me moving the textbox, the cursor would jump all other text boxes to allow the user to enter in a ticket number within the ticket number box after entering 9999 within the PERNR text box. Any ideas????

Please Login or Register  to view this content.

Damian37

**romperstomper** · 06-18-2014, 09:49 AM

Use the Exit event instead of AfterUpdate and then use

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

**nathansav** · 06-18-2014, 09:50 AM

You are putting the logic for the 2 so you'll need to separate your IF one for each, so if A is blank A set focus, if B is blank B set focus

SORRY IGNORE ME :o)