i got trouble in passing my variable from a form to show a data(some data not all) using query, such as "select * from table where field = '" & text1.text & "'

i could't pass the variable when i call the data report using show..
do anyone knows what i have to do...
thanks very much