I'm trying to set up a command button that will check the element EmployeeName to see if it is empty or if the number exists in another database.  If the element is blank or the number doesn't exist, I want to have a message box appear to give direction and then set the cursor in the EmployeeName element.

The programming is below and works through the appearance of the proper message box, however the cursor moves on to the next element rather than returning to the EmployeeName element.  I'm trying to do it via the ThrowFocus command.

Any thoughts on why this isn't working?


var vName as string
var vReturnVal as string
var vName2 as string

If @IsBlank(EmployeeNumber)
     {
           @MsgBox("PLEASE ENTER YOUR EMPLOYEE NUMBER AND THEN PRESS ENTER","","")
           ThrowFocus(EmployeeNumber)
     }      
Else
     {

           vReturnVal = @XLookupSourceList(@Fn, EmployeeNumber, "employee!Empl#", "First Name;Last Name")

           vName=@AccessStringArray(vReturnVal,1)
           vName2=@AccessStringArray(vReturnVal,2)

           FirstName=vName
           LastName=vName2

           Name=firstname+" "+LastName

           ThrowFocus(NameIsCorrect)
     

                 If @IsBlank(Name)
                 {
                       @MsgBox("THAT EMPLOYEE NUMBER IS NOT AVAILABLE.","","PLEASE SEE YOUR SUPERVISOR OR HR MANAGER")
                       EmployeeNumber=""
                       ThrowFocus(EmployeeNumber)


                 }
                 Else
                 {
                 Visibility(NameIsCorrect,1)
                 Visibility(NameIsNOTCorrect,1)
                 }
     }

You say you want it to go to EmployeeName, but your code does not contain a ThrowFocus with that LE in it.

Also, it appears that you are trying to throw focus to NameIsCorrect before it is visible. I haven't tested it, but I would suspect that Sesame cannot put focus in a layout element that is hidden.

And, just to verify the interaction between @MsgBox and ThrowFocus, I pasted your code into a command button in the Customers sample app, changed the LE references, and it seemed to properly put focus into the desire LE after I clicked OK to dismiss the MsgBox.

NHUser wrote on Apr 16^th, 2012 at 3:22pm:


I thought you were trying to run this code from a command button because your first message began with "I'm trying to set up a command button...", but now I see that you have this code in the On Element Exit event of what, the EmployeeNumber? If that's the case, you will have issues trying to make Sesame display a MsgBox, and attempt to put focus back into the element which called the MsgBox.

One solution is to put the code in the On Element Entry event of the next LE. This will work because Sesame will normally be able to send focus to another LE, even if you display a MsgBox.

Let me know if that helps.

Your welcome. Glad to hear that it worked.