Thank you very much, Bret. This is almost exactly what I needed.
There is however one problem: How do I incorporate the WHERE condition to the report in this command? I can't see it from the command template:
Report Template:
DoCmd.OpenReport reportname[, view][, filtername][, wherecondition]
OutputTo Template:
DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]
Thanks in advance
Charles Richard
>>Can anyone tell me how to programatically create a HTML report from an Access report? (I.E. Save as HTML does it through a wizard manually. I want to automate this)
>>
>>Thanks in advance
>>Charles
>
>DoCmd.OutputTo with the acFormatHTML parameter.