Grid.init >>with this >> .recordsourcetype = 4 && SQL >> .recordsource = "select * from mytable "+; >> "where fld1 = trim(thisform.txt1.value) " +; >> "and fld2 = trim(thisform.txt2.value) " +; >> "and fld3 = trim(thisform.txt3.value) " +; >> "into cursor grdCursor" >>endwith >> >>* Lostfocus of textboxes >>thisform.mygrid.refreshCetin
* PEM sheet design time recordsource = "Sele * from ...... where date >= thisform.txt1.value into cursor grdCursor" recordsourcetype = 4 * Or grid.init code with this .recordsourcetype = 4 && SQL .recordsource = "Sele * from ...... where date >= thisform.txt1.value "+; "into cursor grdCursor" endwith * In either case txt1 lostfocus thisform.mygrid.refreshCetin