>I have a grid which lists three fields: Member, ISD, and Campus. The grid >is sorted by member name, and allows the user to select a member. I want >to re-order the grid by ISD or Campus if the user tabs over to one of the >other fields, but preserve the record that was already selected. >Re-ordering the grid is simple enough, by just changing the order and >refreshing the form in the gotfocus event of the testbox in the respective >grid column. The problem is that the record is not preserved. I've tried >trapping the reord number before the SET ORDER and GO RECORD after, but to >no avail. I tried catching the Primary key value, and then SEEKing that >record again, but after the index is set, I can't SEEK on the primary key. >How can I do this? if you save the RECNO() you can just GO to it later also look at the SEEK() command (as oppsed to SEEK ) in the help Arnon