Selection in field problem

[#1]

Hello,

Here i'm attaching my application along with description of problem. Can anyone help me on this.

[hic]

Not sure it can be done… Your selection depends very much on the sort order of the list box and this is not the same as the sort order of the data. I would build the sort order into the search string, e.g. ='<='&Min(LensKey,$(vNoOfLenskey))

and see how far I get with this approach.

[Miguel_Angel_Baeyens · Accepted solution]

Hi Jacq,

I'd use something like the following (using different lines because I have not tested it). What the following does is take the string from the result of concatenating all possible values from field LensKey sorted numeric ascending (as in your listbox) to the nth time (value in vNoOfLenskey).

='(' & Left(
     Concat(DISTINCT LensKey, '|', LensKey)
     , Index(
          Concat(DISTINCT LensKey, '|', LensKey)
          , '|', $(vNoOfLenskey)) -1
     )
& ')' 

Hope that helps.

Miguel

[#4]

Thanks a lot Miguel.