Hi No,
>We would like to display Table's information (such as customer information) in Grid by using Sele .... cammand (eg. Sele customer.name, customer.add1,.....where customer.state = Thisform.txtbox1.value)which controled condition by textbox. Where 's Sele.... command must store ?
The best is to use a view and call Requery("View") in the Valid of the textbox. A cursor via SELECT is possible as well, but it's a little bit ore difficult, because assign a new RecordSource resets the grid.
Christof
--
Christof