Thisform.grid1.RecordSource = SPACE(0) >>>* Create/recreate cursor >>>... >>>Thisform.grid1.RecordSource = "mycursor">>>Thanks for the quick response.
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 = cCurrentRecordSourceSee Grid reconstruction and how to avoid it FAQ #8019.