>Thanks for the response. But I'm still not sure how to select just the specific fields I want in the grid.
>
>Any additional help would be appreciated.
>
>
>Thanks,
>Dan
When you run SELECT you actually select all needed fields:
Select Field1,fFiled6,Field12 From Table1 Into Cursor tmpGrid
Now you set the grid:
With Thisform.Grid1
.recordsource="tmpGrid"
.column1.controlsource="tmpGrid.field12"
.column2.controlsource="tmpGrid.field6"
.....
Endwith
Edward Pikman
Independent Consultant