* Form.init with thisform.mygrid .recordsourcetype = 4 .recordsource = [Sele customer.name, customer.add1,..... ]+; [ where customer.state = Thisform.txtbox1.value ]+; [into cursor crsMyGrid] endwith * txtBox1.lostfocus thisform.mygrid.refreshYou don't even need setting columns in design mode if you don't want special format and columncount. Just drop the grid and size itself.
with thisform.mygrid .columncount = -1 .recordsourcetype = 4 .recordsource = [Sele customer.name, customer.add1,..... ]+; [ where customer.state = Thisform.txtbox1.value ]+; [into cursor crsMyGrid] endwithIf you put this code in a custom method you could send SQL as a parameter to change info on the fly :)