OutputTo Method

[Ayala]

Hi,
I'm trying to Output a Report with a Snapshot Format.
It works fine, but I want to force the user to save the
file with a name saved in variable strFileName.
So I don't want to let the user give a name to the output
report. This name will be given by code.
Someone know how to do this?

Best wishes,
Ayala

 

[Steve Schapel]

Ayala,

DoCmd.OutputTo acOutputReport, "fred", acFormatSNP, strFileName

- Steve Schapel, Microsoft Access MVP