J G
asked on
How to make query not show results in table form go straight to report
I have a form with 2 text boxes and a search button to enter a date range criteria that will run a query. I also built a report that will display the results of the query as well as hide duplicates from the query.
Currently, when I hit the search button the query runs, and the results display in table view. Then I have to run the report after.
I want to be able to hit the search button, and have the query run without displaying results in the table view and go straight to displaying the results in the report print preview. Is this possible?
Currently, when I hit the search button the query runs, and the results display in table view. Then I have to run the report after.
I want to be able to hit the search button, and have the query run without displaying results in the table view and go straight to displaying the results in the report print preview. Is this possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So I will just have the 2 text boxes, enter my date range and have a command button on the form that will run the report?
ASKER
I got it, nevermind.
ASKER
I don't quite understand your explanation. If I don't run the query first, the report doesn't display the query results.