if u use data control
in the event click command button u type this code:

Code:
data1.recordsource = "select * from table1 where field1 = " & text1.text
data1.referesh
to view all result , u can use data grid.