Peter,
What happens if you use 'alias' instead of 'fields'. Keep the Rowsource the same.
Also, check with the debugger to be absolutely certain nothing changed the order of your table.
HTH
Barbara
>Barbara,
>
>Hi!! Actually, the listbox has only one of about 20 fields in it... the name. I also have an index in the file for
>the name field as well. In the DE on the form, I set the ORDER for the file (apmas) to the name of the field
>(name). The listbox has one column (name). The rowsourcetype is set for 6-Fields and the rowsource is
>set for apmas.name. Controlsource is blank and bound to is false.
>
>This works, sort of. It moves the record pointer alright but the displayed list isn't sorted. I thought that was all
>I needed to do to sort the list???
>