Question on query preview

[magster06]

Hello all,

I have yet another beginner question and I have not been able to find the answer searching through the topics.

I have a form (DateSearch) with 2 datepickers dtStartDate and dtEndDate along with a command button cmdSearchDates.

I created the macro to search the dates from a query (qDateSearch) and this works as it should. I set the macro to "view" to datasheet.

I then create another macro to open a report designed for the output of the date search.

Here is my problem:

When I click the Search Date button, the macro brings up the datasheet and then the report (rptDateSearch) pops up.

Is there anyway to stop the datasheet form from poping up and just let the report pop up?

I noticed that the macro to pop up the datasheet can be set to "preview" , but I cannot figure out how to manipulate it.

Thanks ahead of time!

 

[pbaldy]

If the report is based on the query, the macro does not need to open the query, just the report. The report will "open" the query internally.

 

[magster06]

SWEEEEET!

Works great Mr. pbaldy! Thanks again for the help!

 

[pbaldy]

No problemo!!