Moving focus back to first textbox

[LisaPatch]

Hi guys

I have two textboxes
1. txtpolno
2. Textbox5
I am writing the following code to double check if the person has inputted the right policy number. If yes then the cursor should move to the next control but if not then the above two textboxes shoule be blank and the focus should be at txtPolNo.But the code moves the focus to the next control always.

Please Login or Register  to view this content.

[LisaPatch]

Can anyone please answer my question?

Thanks

[john55]

hi,
not sure but ....just try this one!

Please Login or Register  to view this content.

[LisaPatch]

But if its in the change event of a textbox then it will fire even we type just 1 character in the textbox.

Any other ideas?

[romperstomper]

The issue you have is with timing. If you step through your code you will see that the focus does get set to your control, but as soon as the routine ends, the focus switches to whatever control was next in the tab order. (basically, the tabbing to the next control is suspended while your code runs, then continues as normal.)

[Kenneth Hobson]

I could not duplicate your problem. You can post a sample workbook if you like.

[LisaPatch]

Hi

Please see attached the workbook. I hope you will be able to help me now.

Thanks

[snb]

Why do you allow the user to enter 'invalid' input in the first place ?
By disabling all other objects in the frame you can force the focus to remain in the same textbox.

[LisaPatch]

Hi snb

Thanks for your reply. In the actual workbook there are lots of textboxes and drop down boxes so I can disable all of them to resolve this issue.

Can you think of any other workaround of this problem?

Thanks

[snb]

Like I said: put these two in a separate frame.
Disable the textbox that hasn't the focus.
Enable it if the input is correct.

But why asking the user to enter the same thing twice ??

[LisaPatch]

Hi snb

My manager asked me to double input thing for policy number like we normally have for the password creation in various websites.

I tried putting the two textboxes in a frame and it still doesn't work as required.

Can you make changes in the attached workbook so that I can come to know exactly how it goes.

Thanks

[snb]

How will the policy number's correctness be checked ?

[LisaPatch]

Snb, If the policy numbers in both textboxes are same then that means its right otherwise a message should display that policy numbers in two textboxes don't match with each other.

Thanks

[snb]

I see.
If it's a new number why not generating it by the code ?
If it's existing why not retrieve it from the database, according to name ?

[LisaPatch]

snb, I think i didn't make it clear in the above posts. My company receives Insurance policies letters from its customers and now the users who will be using the system will input the policy numbers in the system by reading it from the letters.

So we can't generate it automatically through the code.

I hope you now understand my problem.

I just have a problem of moving cursor at the right textbox and apart from that everything works fine.

Thanks

[romperstomper]

I would either:
1. use the Exit event to simply highlight both textboxes in red if they don't match (you could also use a label with an error message) and then have the Save button's code verify the two before it allows a save; or
2. Simply cancel the input into the second textbox rather than trying to set the focus back to the first one.

[LisaPatch]

Hi Romper

I am writing the following code but still the focus still goes to the next control.Please help me to figure it out.

Please Login or Register  to view this content.

[romperstomper]

I can't replicate that behaviour in your sample workbook.