I want to test data entry against some codes that I could Xlookup for their description; however, i bomb out in the middle of my If Result = 1;2;3....statement..any hints?



If @IsBlank(RESULT) then
     {
     RESULT =
     RESULTDESC =
     }
Else
     If Result = 1;2;3;4;5;6;7;8;9;10;11;12;5a;7a;7b;
     {
           RESULTDESC = @XLOOKUP(D:\Sesame\Data\Result Codes.db, RESULT, RESULT CODES!RESULT CODE, RESULT DESCRIPTION)
     }
     Else
     {
           @MsgBox(Data needs to be null or a valid DISPOSITION CODE, 1;2;3;4;5;5a;6;7;7a;7b;8;9;10;11;12., , )
     }

Hello Nancy,

If Result = 1;2;3;4;5;6;7;8;9;10;11;12;5a;7a;7b; 

is not a valid SBasic statement. You can do this compare several ways.

One way is to use Or to string together multiple conditionals. Ex To see if Result is a 1, 2 or 3

If((Result = "1") Or (Result = "2") Or (Result = "3"))  

Another way is to use @SearchStringArray() to compare the field against a list of good values. Ex

If @Len(@SearchStringArray(Result, "1;2;3;4;5;6;7;8;9;10;11;12;5a;7a;7b")) > 0 Then 

-Ray