You miss the "Safe Select" concept. When you change the recordsource, you also reset the whole grid. Read more here: http://weblogs.foxite.com/andykramek/2005/03/19/using-a-safe-select-to-preserve-your-grid/

>Attached are two pics. They are of a grid - the one shows how the grid looks the first time the search is used. The other shows what it looks like any subsequent time. I set up the header captions, column/text colors etc in the property editor, at all looks fine the first time around. All subsequent times - no go. And the first time around, I can click on the data in the columns, and the proper job gets pulled up for editing - subsequent times - no. Here is the code..
>
>

>SELECT ad1,custno,ponum,inv,orddate,invdate FROM jobs;
>WHERE custno=mcustno;
>ORDER BY ad1,custno,orddate INTO CURSOR possibles
>SELECT possibles
>thisform.grid2.RecordSource='possibles'
>thisform.grid2.RecordSourceType= 1
>ThisForm.Grid2.refresh
>

>
>It makes no difference if I set the record source/control sources in the property editor, or not. Only by writing it in as above does it populate the grid. I can programmatically paint up the grid again, but it still doesn't let me click on a row to take me to the job editor...
>
>Any ideas what I am missing?