Hello, I have form to make searches using text boxes. I click on a command button to run the queries. One of these queries, named query1 uses this criteria: Like "*" & [forms]![frmintercept]![txtinter2] & "*"
The result of my query is displayed with a form named frm1. On this form I have added a command button to print a report( who's source is obviously the query named query1). When I click on the button, again I am asked to type the search criteria through an input box. Is there a way I could just print the report without having to retype the criteria twice. Is there a way I can associate the criteria of the search box to the command button that makes the report print?
The result of my query is displayed with a form named frm1. On this form I have added a command button to print a report( who's source is obviously the query named query1). When I click on the button, again I am asked to type the search criteria through an input box. Is there a way I could just print the report without having to retype the criteria twice. Is there a way I can associate the criteria of the search box to the command button that makes the report print?