Applying filter to a report before sending to Excel

TheCronus

The Ruler of Titans
Local time
Today, 11:30
Joined
Dec 11, 2004
Messages
6
Hi,
I have a report of which record source is a query defined in my Queries.

I want to apply apply filter to the query before the command

DoCmd.OutputTo acReport, stDocName, acFormatXLS

I tried to open the report with the following command before sending the output

DoCmd.OpenReport "my_report_for_excel", acViewDesign, , , acHidden

Then wanted to modify the filter property.

But no sense... :(

Please show me the way...

Thx.
 

Users who are viewing this thread

Back
Top Bottom