>Hi,
> I have a grid that the recordsource is set to a cursor. And in the form, i will allow to add in new record into the cursor and display in the grid. But i wish to reorder(order by a specific field) the record when i added the record into the cursor.
> Is it got any way to reorder the cursor without reSelect.... into another cursor and set the grid recordsource again ?
>thanks
>
>regard,
>kengwen

You can just index the cursor on the desired field. Note that if you use the table buffering for your cursor you will not be able to index the cursor in this mode, so you have to switch the buffering for your cursor to 3 (row) first, index it and set the buffering mode to 5 again.