>>>I need to close and reopen the data source (a cursor) for a grid without adversely affecting the grid.
>>

Thisform.grid1.RecordSource = SPACE(0)
>>* Create/recreate cursor
>>...
>>Thisform.grid1.RecordSource = "mycursor"

>>Thanks for the quick response.
>>
>>When the cursor is refreshed, the grid is now showing all columns instead
>>of a subset.
>
>You've to set recordsource of the grid to the empty string before you do anything to a cursor.

This is what I am doing, here is the code:

cCurrentRecordSource = This.Parent.Parent.pagDetails.grdOrDetails.RecordSource
This.Parent.Parent.pagDetails.grdOrDetails.RecordSource = SPACE(0)

SELECT * ;
	FROM OrDetail ;
	INTO CURSOR curCurrentOrder ;
	WHERE OrDetail.cOrder = cValue ;
		AND ALLTRIM(OrDetail.cOrder) IN (Select Drawings.cOrderID FROM Drawings) ;
	READWRITE

This.Parent.Parent.pagDetails.grdOrDetails.RecordSource = cCurrentRecordSource