thisform.grdDetail.RecordSource = '' SELECT cjobno,dcreate,dserved,ntotcalls,dtrack,ctrackto,cInstname,ccity,dlastcall,tlastcall ; from cSQLPT1 ; INTO CURSOR cur_detail ; WHERE ctrackloc = ALLTRIM(thisform.grdSummary.column1.cgridtextbox1.Value) ; ORDER BY dtrack DESC, cjobno SELECT cur_detail GO TOP WITH thisform.grdDetail .recordsource = 'cur_detail' .column1.controlsource = 'cur_detail.cjobno' .column2.controlsource = 'cur_detail.dcreate' .column3.controlsource = 'cur_detail.dserved' .column4.controlsource = 'cur_detail.ntotcalls' .column5.controlsource = 'cur_detail.dtrack' .column6.controlsource = 'cur_detail.ctrackto' .column7.controlsource = 'cur_detail.cinstname' .column8.controlsource = 'cur_detail.ccity' .column9.controlsource = 'cur_detail.dlastcall' .column10.controlsource = 'cur_detail.tlastcall' .sethighlightbar() .refresh() ENDWITH