Link to home
Start Free TrialLog in
Avatar of J G
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?
ASKER CERTIFIED SOLUTION
Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of J G
J G

ASKER

How Do I just "run the report?"

I don't quite understand your explanation.  If I don't run the query first, the report doesn't display the query results.
Avatar of J G

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?
Avatar of J G

ASKER

I got it, nevermind.