>Good Morning,
>
>I have a list box with a number of records which is a result of an SQL query. I have 2 buttons labelled UP and DOWN. what I would like to do is when I click on a record in a list box and then click UP or DOWN the record will move to the required position in the list box.
>
>Does anybody have any ideas?
>
>Many Thanks
You can't do that with SQL rowsources. You should change the order in source cursor and requery. To do that you might have a 'sorter' field in source and change its value (use a readwrite cursor).
Cetin