hi
i try to get this.value form mylist as under
but if try to insret 1 it get 10..press again i get at text1 11,....

SELECT DISTINCT billno FROM mstr INTO CURSOR MyCursor
ThisForm.List1.RowSourceType= 6
ThisForm.List1.RowSource = "MyCursor"

>M.
>
>Not sure what you're getting at. Could it be that when numeric data are treated as character, they are not in numerical order, e.g. 1, 2, 3, ... 10, 11, ... 19, 20, 21 becomes:
> 1, 10, 11, 12, ... 19, 2, 20, 21 ... etc.
>
>i.e. ASCII order.
>
>
>Terry