>I am using a grid to display data in a cursor. I use the index command to display the data in a certain order based on three fields. If a year is entered which should appear at the top of the grid, the order does not change. If a year is entered that should appear somewhere in the middle of the grid data, the values change interactively, as they should. Does anybody know why or how I can get the data to sort in the correct order if a record should be moved to the top of the list?
>
>If I browse the cursor, the data is in the correct order but not refreshed in the grid. I have been unsuccessful trying to use the refresh and setfocus commands.
>
>Thanks for the support,
>
>Lance

I use the following code in an incremental search text box InterActiveChange method:

ThisForm.LockScreen=.t.
with ThisForm.grdCustomer
	.SetFocus()
	do while .RelativeRow > 1
		.DoScroll(1)
	enddo
	.Refresh()
endwith
This.SetFocus()
ThisForm.LockScreen=.f.