I have a main form which displays data and the textbox from which users can type a keyword as a query. when the query is run, a datasheet is opened with the query results. since the main form already has all the fields, i want my query to display the results exactly in the same form where is was run. similar to what "find" results can do. can anyone help? thanks.

Would the filter (by form or selection) help you better? The advantage of a query would be to save the results, but if you just need to view them in that instance, filter would probably better suit your needs, and then it would be displayed in the form you've already created.

thanks for the advice. is there a way to print the results of the "filter by form" function?

Just print out the form. To answer the last question.