Set Focus

[rvc81]

hi,

my user form has 3 text boxes

Text Box 1 = uf_UserInfo.txt_UI_EmpName
Text Box 2 = uf_UserInfo.txt_UI_EmpNameID
Text Box 3 = uf_UserInfo.txt_UI_Dept

If I use the below code then it works fine,

Please Login or Register  to view this content.

However; I cannot get 1 or all 3 criteria's to match. If I use the following code then I get an error? I am sure it is to do with 'SetFocus' method.

Please Login or Register  to view this content.

Please help.
Thanks
R

[snb]

What is the essence of focus ?
In optometrics doublefocus can be achieved, in VBA it can't.

[Andy Pope]

as snb points out only one control can have focus.
You need to check each textbox and deal with the first empty one

Please Login or Register  to view this content.

When you use code that check all the textboxes at once you will detect an empty one but you will not know which one to set focus to.

Please Login or Register  to view this content.

[rvc81]

Thanks guys..