snapshot file auto save

[franksirvent]

Hi there

I would like to automatically save a report to snapshot format.
I have read on other messages that I cannot apply a filter with the docmd.outputto however I need to be able to do so.

Could anyone advise how to do this?
Someone mentioned to pre-filter however I am not to sure how to do this...

Any help is appreciated

DoCmd.OutputTo acOutputReport, stDocName, "Snapshot Format", "L:\KN2002\SNAPSHOTS\TESTING.SNP", False

 

[GingerR]

i think what someone means is to put your criteria into the report record source (table or query that the report is based on)

i.e. put [Enter Name:] or reference a form where you have parameters (Forms!Main!txtName) (or whatever) in the criteria or the recordsource. then when the report opens, it's already ready to go.