Yes it works as far as displaying in the right order, but the speedsearch does not work correctly still. I still get the same results. If the order is set to formname in the temporary table created, the list diplays in the correct order but the search works incorrectly. If I have:

1
25
35
125

and I am on 1 in the list and I type 125 I go to 25.

>I just tested this, and it does work when you create an index on the VAL() of the FormName field.
>
>select str(formname, 10, 0) as FormName, "Desc" as Descript ;
> from AcordFrm into cursor crsForms
>sele crsForms
>index on val(formname) tag formname
>index on descript tag descript
>
>Since DESC is a reserved word you may have problems. I would alias it in the SELECT command and use that instead.
>
>>Is there a quick way to select from a table into another table and change the type from numeric to character during the process? In this form the listbox is simply used as a selection tool...
>>
>>Current Live fields in acordfrm table:
>>
>>acordfrm.desc c(50)
>>acordfrm.formname n(10,0)
>>
>>Desired for testing in taccord table:
>>
>>acordfrm.desc c(50)
>>acordfrm.formname c(10)
>>
>>Can't find anything like that in help - I've never done it. Is it possible without stepping through the table record by record and converting the values in the temporary table?
>>
>>TIA,
>>Tracy