is it possible to query a table and only print out one record using data report designer?

if so, how would you write a query such as

select * from table where field in table = value in textbox on a form?